C
CindyHoskey
Hi, I've seen other posts on this subject but I'm afraid I don't understand.
I'm trying to create a "% of" calculated column on a Pivot table. The table
looks like this:
Manager #Emp #Cons Total
A 8 2 10
B 12 8 20
C 20 5 25
I would like to add a column showing #Emp as a percentage of Total. So that
fifth column would look like this:
%Emp
80%
60%
80%
I understand how to add a calculated column, and if I use the "% of column"
calculation it works. But I need the "% of" calculation and I don't
understand what to put as the "Base field" and "Base item". No matter what I
put there I seem to get only "#N/A".
I hope this is clear. Any help would be appreciated. Thank you.
I'm trying to create a "% of" calculated column on a Pivot table. The table
looks like this:
Manager #Emp #Cons Total
A 8 2 10
B 12 8 20
C 20 5 25
I would like to add a column showing #Emp as a percentage of Total. So that
fifth column would look like this:
%Emp
80%
60%
80%
I understand how to add a calculated column, and if I use the "% of column"
calculation it works. But I need the "% of" calculation and I don't
understand what to put as the "Base field" and "Base item". No matter what I
put there I seem to get only "#N/A".
I hope this is clear. Any help would be appreciated. Thank you.