customise total calculated in pivot table

Y

yann

hi all,

I am trying to customise how my fields in a pivot table is summarised. The existing ways of how data are summarised e.g. Sum, Count, Average, Max, Min, Product, etc are not suitable for my needs.

E.g. of the kind of calculation for totals I need is: Sumproduct(qty1, qty2, qty3, going price1,going price2, going price3)/sum(qty1, qty2, qty3)

Please help. Thanks in advance.

yann
 

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

Picking a value from a list in a table 5
Incorrect total of calculated field in pivot table 1
Average of % in pivot table 1
Problem with Calculated item in Pivot Table 0
Problem with Calculated item in Pivot Table 1
Calculated field problem in a Pivot table 0
Conditional calculated field in pivot table? 0
Pivot tables calculated fields 2

Top