ExcelBanter

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

FARAZ QURESHI

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.


All times are GMT +1. The time now is 08:56 PM.

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