Not getting subtotals correctly in pivot table.

[#1]

Hi, I am not getting the pivot table subtotals correctly. screenshot is like this,

help please

[marcus_sommer]

It will be depend on the kind of expression if you get a correct subtotal - something like sum(sales) will always work but something like quantity * price won't - in such a case you might need: sum(aggr(quantity * price, articel)). This meant you will probably need:

sum(aggr(YourExpression, Dim1, Dim2))

- Marcus