PIVOT TABLE CUSTOM FIELDS

F

FARAZ QURESHI

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PIVOT TABLE CUSTOM FIELD 0
Pivot Table Comparisons in Excel 2007 2
Calculating total amount in a Pivot Table 1
Add custom cost rate to rate tables 2
Pivot Table - Compare Dates & calc. % 1
Pivot Table - Duplicated Data on Row Labels 0
Pivot table - Problem with % 5
Multiple Fields In Multiple Ranged Pivot Table 0

Top