S
SUMIF
I have a pivot table for financial report,
e.g. Sales xxx
COS xx
Expenses xx
Grant Total x
How can I add a subtotal "Gross Margin" (Sales less COS) without insert more
level in the table?
I tried to add calculated field but it work in column not in row.
e.g. Sales xxx
COS xx
Expenses xx
Grant Total x
How can I add a subtotal "Gross Margin" (Sales less COS) without insert more
level in the table?
I tried to add calculated field but it work in column not in row.