I want to remove the percentage of row total in the pivot table

[Shellybelly]

Does anyone know how to remove the percentage of row total in a pivot table. I only want the sum of the row total but the percentage of row column always say 100% and I want it to be removed. Does anyone know how?

[MarvinP]

Hi Shellybelly,

Drag that column out of the value area and back onto the field list.
http://www.excelfunctions.net/Excel-Pivot-Tables.html

[Shellybelly]

Thanks MarvinP but if I remove it from there...it also removes the other columns with percentages. I've attached the file to show. I only need the percentage of the grand total row be removed.

[Andy Pope]

Not sure can remove the %'s from the Grand Total Row.

You can hide them though with a custom number format on the total row
[>1]0;;;