LinkBack URL
About LinkBacks
I want a second column for each column which shows percentage of total as you see in the pivot table. How to do that?
(I can create this pivot table without this percentage columns.)
I want a second column for each column which shows percentage of total as you see in the pivot table. How to do that?
(I can create this pivot table without this percentage columns.)
Add Employee as a Value field again, right click the new field in the pivot table and select Show Values ... as % of Column Total.
You can change the name and number format by right clicking the field and selecting Value Field Settings..
If posting code please use code tags, see here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks