ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   PIVOT TABLE CUSTOM FIELDS (https://www.excelbanter.com/excel-discussion-misc-queries/150632-pivot-table-custom-fields.html)

FARAZ QURESHI

PIVOT TABLE CUSTOM FIELDS
 
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.



All times are GMT +1. The time now is 11:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com