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