Thread: pivot table
View Single Post
  #1   Report Post  
SUMIF
 
Posts: n/a
Default pivot table

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.