fairlyfaries
New Member
- Joined
- Nov 21, 2020
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
I get my pivot table to show any type of percentage of the total. In my data set I have organizations that are reporting their number of employees in different occupation levels (Board, Executive, Supervisors, Etc.). I am now trying to get it to show me not only the total number of each type of occupation, but their corresponding percent of the total sum of occupations. I have the sum of the occupations also inserted as a calculated field. When I do Show Values as % of Occupations, nothing happens. Also when I do Show Values as % of grand total or row total, it just brings back 100%, and when I do show values as % of parent row it makes the cell blank. Please help, I am new at pivot tables and so confused, thank you!