PIVOT Partial Sums

[bsbernabe]

Hi,

I have pivot Table, base on my observation the Partial Sums is not equal to Total Sum, I am trying to get the Max for EVALUATED_PRICE, here my script in expression max(EVALUATED_PRICE) but the Total Partial Sum is not equal see below screenshot

Suppose to be :

32,640          24,160

28,400          24,160

61,040          48,320

Best Regards,

Bing

[Anil_Babu_Samineni]

Please attachr QVW

[antoniotiman]

Try this

Sum(Aggr(Max(EVALUATED_PRICE),Dim1,Dim2,Dim3))

[jonathandienst · Accepted solution]

You need a Sum of rows type of expression, like:

Sum(Aggr(Max(EVALUATED_PRICE), [MATERIAL GROUP DESCRIPTION], [YEAR SOLD (BN)], CATEGORY, [MATERIAL DESCRIPTION]))

(You need all the pivot dimensions in the Aggr - I am assuming that they are the bold fields, Change if necessary)

[bsbernabe]

Hi Jonathan,

It's working thank you so much for your support i really appreciate.

Best Regard

Bing