Pivot table calculated column
 

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.

Pivot table calculated column
 

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

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


--
Pecoflyer

Cheers -
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=94884