Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table calculated item | Excel Discussion (Misc queries) | |||
Pivot table Calculated Field | Excel Discussion (Misc queries) | |||
Calculated Field and Calculated Item in Pivot Table | Excel Discussion (Misc queries) | |||
pivot table formulas for calculated field or calculated item | Excel Discussion (Misc queries) | |||
Pivot Table with Calculated Fields | Excel Discussion (Misc queries) |