Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
Please attachr QVW
Try this
Sum(Aggr(Max(EVALUATED_PRICE),Dim1,Dim2,Dim3))
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)
Hi Jonathan,
It's working thank you so much for your support i really appreciate.
Best Regard
Bing