Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table Calculated Field
I have a column of Salesmen together with an associated column of their sales.
Let's say that the total of all the sales is £100,000. I would like to insert a calculated field that shows the % contribution that each salesman makes to the total sales. Is this possible in a Pivot table? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table Calculated Field
As answered in microsoft.public.excel.programming:
Instead of a calculated field, you can use a custom calculation: Add another copy of the Sales Total field to the pivot table's data area Right-click on a cell in this new column Click Field Settings, and click the Options button From the Show Data As dropdown, choose % of Column. Click OK RodneyJ wrote: I have a column of Salesmen together with an associated column of their sales. Let's say that the total of all the sales is £100,000. I would like to insert a calculated field that shows the % contribution that each salesman makes to the total sales. Is this possible in a Pivot table? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculated Field and Calculated Item in Pivot Table | Excel Discussion (Misc queries) | |||
pivot table calculated field | Excel Worksheet Functions | |||
Re-using calculated field in another pivot table | Excel Discussion (Misc queries) | |||
pivot table formulas for calculated field or calculated item | Excel Discussion (Misc queries) | |||
pb with calculated field in a pivot table | Excel Discussion (Misc queries) |