PIVOT TABLE CUSTOM FIELD

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 FIELDS 0
Calculating total amount in a Pivot Table 1
Pivot Table Totals 0
Slicers and Calculated Items in Pivot Table 2
How do I calculate a weighted average in a pivot table? 0
PivotTable - Filter Row 0
Calculated Fields in Pivot Tables using Existing aggregates 0
Pivot table, IF function, calculated item versus calculated field 1

Top