Hello friends,
I have an attached pivottable, it has 2 columns US and NonUS and the columns are counting. I need an additional column that would show the percentage of between the US and TOTAL.
you know how much the US occupies of the total?
Thank you so much in advance!
You can add the count of Bill field to the table again, right-click it and choose to show values as % of Row total, but it will show the percentage for both US and non-US. To avoid that you have to manually hide the column you don't want or use PowerPivot.
Remember what the dormouse said
Feed your head
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks