Pivot 2007 - two sum of, only want detail of one

K

Karen

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top