editing pivot table

Feb 26th, 2002, 01:11 AM

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

Mark W. · Feb 26th, 2002, 07:45 AM

See http://www.mrexcel.com/board/viewtop...=632&forum=2&3

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 26th, 2002, 01:11 AM	#1
Guest Posts: n/a	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 ...

Feb 26th, 2002, 07:45 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	See http://www.mrexcel.com/board/viewtop...=632&forum=2&3