| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
PIVOT TABLE CUSTOM FIELD
I have a pivot table showing Field 1 with Sum of Amount where rate is 0
& Field 2 with Amount*Rate. I want a third CUSTOM field to show Field 2/Filed 1 so as to calculate the wieghted average rate; and a CUSTOM field 4 showing CUSTOM field 3 multiplied by 11% so as to determine the future budgeted rates. All guidance & assistance shall be highly appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CUSTOM FIELD FOR PIVOT | Excel Discussion (Misc queries) | |||
| CUSTOM FIELD OR SUB TOTAL IN PIVOT TABLE | Excel Discussion (Misc queries) | |||
| How to make a field created a part of the Pivot Table Field List? | Excel Discussion (Misc queries) | |||
| Custom field in Pivot Table? | Excel Discussion (Misc queries) | |||
| Pivot Table - Custom Row Field | Excel Worksheet Functions | |||
Linear Mode
