Total in Pivot Table with different Weights

[Anonymous]

Hello,

I am trying to do a pivot table however the total is not correct.

as you can see the sum o ftotal weigh should be 2.4+ 4.5= 6.9 and it is not doing the sum the right way.

¿how can it be done?

i atached the qwd and the data.

thank you

[sunny_talwar]

May be try this:

Sum(Aggr(quantity*price*Weight, type, month))

[Anonymous]

sorry wrong qwd

[sunny_talwar · Accepted solution]

Try this:

Sum(Aggr(sum(quantity)*avg(price)*Weight, month, type))

[Anonymous]

thank you very much.