Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
I am not sure,
If you can customize that function in expression itself
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.
Hi Guys , can you help me on below link ?