G
Guest
Guest
hi guys,
some help is needed:
having a calculating cell in a pivot table multiplying a number with a percentage e.g.
1000 x 20% = 200 (first line)
500 x 10% = 50 (2nd line)
=> sum line 1500 x 30% = 450 (but I want to see only 250 as total in the sum line and to hide the sum of the percentages, which is crap).
How is that possible ?
Many thanks ...
some help is needed:
having a calculating cell in a pivot table multiplying a number with a percentage e.g.
1000 x 20% = 200 (first line)
500 x 10% = 50 (2nd line)
=> sum line 1500 x 30% = 450 (but I want to see only 250 as total in the sum line and to hide the sum of the percentages, which is crap).
How is that possible ?
Many thanks ...
