ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot 2007 - two sum of, only want detail of one (https://www.excelbanter.com/excel-discussion-misc-queries/264379-pivot-2007-two-sum-only-want-detail-one.html)

Karen

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.


All times are GMT +1. The time now is 09:44 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com