| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Pivot Tables, calculated fields
I'm trying to add two calculated fields to a pivot tabe. I'd prefer that the
field calculation the takes a row item quantity or dollar figure and calculates the item as a percentage of the total. Such as region xx has 85% of the total sales units but only 78% of the total sales dollars. Can anyone help me? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
| How do I fix column widths in Excel Pivot Tables? | Excel Discussion (Misc queries) | |||
| Excel 2002 -> Problem with calculated fields in Pivottable | Excel Discussion (Misc queries) | |||
| How Do You Permanently Format Fields of a Pivot Table? | Excel Discussion (Misc queries) | |||
| Pivot Tables | Excel Discussion (Misc queries) | |||
Threaded Mode
