Totals in pivot table

[Anonymous]

Hi everyone,

I'm facing a problem with my development. I'm using a pivot table with 3 expressions:

Sum(Quantity), Sum(Pieces) and Sum(Quantity) / Sum(Pieces).

What I want is the total of the rows on each of these expressions. But, on the third column, the total is equivalent to TOTAL(Quantity)/TOTAL(Pieces) and not the sum of rows.

On my example below, I need to have 322 instead of 121.

I know I can fix this problem by using a simple table but I really need a pivot table.

Is there a solution to fix this ?

Thanks a lot,

Quentin

[Gysbert_Wassenaar]

You will have to use the aggr function:

sum(aggr(Sum(Quantity) / Sum(Pieces),Dim1, Dim2, ..., DimN))

Replace Dim1, Dim2, ...,DimN with the dimensions of your pivot table.

[saumyashah90]

I am not sure,

If you can customize that function in expression itself

[Anonymous]

Hi guys,

Thanks for your answer. Unfortunately, my dimensions are three cyclic groups and the period, so I tried to use your formula on my group and on all the dimensions in this group, it didn't work well.

[#5]

Hi Guys , can you help me on below link ?

Pivot table how to use Aggr to compute Diff % ?