Step 4: Pivot-like summary with formula.
Create a summary table in the “Report” sheet:
=SUMIFS(DataTransaction! D:D, DataTransaction! C:C, A5, DataTransaction! B:B, “Expendition”)
A5 = subcategory name (Salary, Rent, Advertisement, etc.).
Drag down. Each line automatically calculates the total per category.