Hello. I have 10 items in my row labels in my pivottable. For the associated value there are also ten items. How can I get each row label to show % of TOTAL but have the sub-row labels (the values) show the % of each individual row label? I couldn't find an option for this but there has to be one.
Hi ammartino,
I'm not sure 2007 Excel Pivots give all the options the newer versions give. See:
http://contextures.com/xlPivot10.html
and look at the % of Row section to see what the newer versions show. I think a newer version gives you the options you want.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks