Only getting 100% on pivot table for row percentages

Thanks for the response but I'm not sure what you mean Norie, there is no % of grand total in the value field settings and % of total doesn't work. If there something else I've missed with that?

I just realised I didn't say im using excel 2007 and when I right click and select value field settings with the tab show value as the options are:

Normal
Difference from
% of
% Difference from
Running total in
% of Column
% of Row
% of Total
Index

I have tried many for several hours, none of these work, is this where % of grand total should be? I think the problem here is that there is no rows grand total, despite my enabling it in options so the option isn't in the value field settings. Is there another way to get this? or some other way around the problem?

Yea, spent a long time tooling around with it, but % of column would be the wrong % anyway.

Hi Kevin,

To put number field in values distorts the graphs and doesn't seem to create any grand totals unfortunately, so there's no option for it but thanks for the idea!

Well any would be a start but a percentage by number really. So number 7 has a percentage of 100% then then number 8 and 9 would be broken into 4 percentages so simply % by row.

i am looking for % by row... so 7 has only one tag, the other 2 numbers have 4 tags so percentages for those numbers will be about 80%, 5%, 10%, 8% for number 8. Something like that but i cant make the pivot table produce any percentages.