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.
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.