Totals in Pivot Table

[psk180590]

Hello All,

I have recently encountered a problem with the Totals in my Pivot Table(Show Partial Sums).

Below is my Expression which calculates Sum(Quantity) for various Dimensions:

if(vBillNum=1, count({<Flag_Actionspaket={'1'}>} distinct %Key_Header),sum({<Flag_Actionspaket={'1'}>}Quantity)).

But, the Sum displayed in Pivot Table varies from Dimension to Dimension.

I have already learnt about using the Aggr function, but not sure how and where to implement in my case. Could some one throw some light into this topic.

TIA!!

[stabben23 · Accepted solution]

If you start an Expression in pivot With if, then a total will not get calculated.

you need to wrap a sum around Your Expression and probably a aggr function.

sum(if(vBillNum=1, count({<Flag_Actionspaket={'1'}>} distinct %Key_Header),sum({<Flag_Actionspaket={'1'}>}Quantity)))

or

sum(aggr(if(vBillNum=1, count({<Flag_Actionspaket={'1'}>} distinct %Key_Header),sum({<Flag_Actionspaket={'1'}>}Quantity)),Dimensionfields))

[psk180590]

Thanks Staffan,

The second option with Aggr suits my requirement.