Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot 2007 - two sum of, only want detail of one
I have two data calculations in my pivot table: Amount difference and %
difference. I want to view the detail of the amount difference and its subtotal but I only want the subtotal of the % difference. In other words, I don't want to see the 0.0%, -93.5%, 0.0%, -99.8% but I want to see 13.0% & ..7%. And I want to retain all of the amount differences. Sum of Doc Amount3 (amt diff) Sum of Doc Amount2 (% diff) $1,495,926 0.0% ($1,313,830) -93.5% Subtotal $182,095 13.0% $2,838,257 0.0% ($2,819,666) -99.8% Subtotal $18,591 0.7% Any help is greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table - show ALL detail? | Excel Discussion (Misc queries) | |||
how do i only see subtotals in a pivot and hide the detail | Excel Worksheet Functions | |||
Pivot Table - cubed detail | Excel Discussion (Misc queries) | |||
show detail in pivot table | Excel Discussion (Misc queries) | |||
Pivot table subtotals before detail | Excel Discussion (Misc queries) |