Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table Calculated Field
I have a column of salesmen and an associated column of their sales which
totals £100,000. I want to insert a calculated filed that shows the percentage that each salesman contributes to the £100,000 total. Is this possible in a Pivot Table? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table Calculated Field
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 and an associated column of their sales which totals £100,000. I want to insert a calculated filed that shows the percentage that each salesman contributes to the £100,000 total. 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 | |||
How do I remove a Calculated Field from the Pivot Table field list | Excel Discussion (Misc queries) | |||
Pivot table, IF function, calculated item versus calculated field | Excel Discussion (Misc queries) | |||
Calculated Field and Calculated Item in Pivot Table | Excel Discussion (Misc queries) | |||
Pivot Table Formulas Calculated Item / Calculated Field | Excel Programming | |||
pivot table formulas for calculated field or calculated item | Excel Discussion (Misc queries) |