Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
updating pivot table to include additional rows | Excel Discussion (Misc queries) | |||
Pivot Table - Multiple consolidation Range | Excel Worksheet Functions | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
pivot table | Excel Worksheet Functions |