Pivot table calculated column

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.
 
P

Pecoflyer

Hi,
does this link 'Excel -- Pivot Tables -- Custom Calculations'
(http://www.contextures.com/xlPivot10.html) provide any help?

CindyHoskey;339269 said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top