Subtotal in pivot depending of order of dimensions

[Qliksense_77]

Hi

In pivot tabel I only want subtotals (the red marks below ..same as dimensionality()=1) when dim1 comes first.

If the user pulls dim2 to be  dimensionality()=1 (at the yellow mark below) then I dont want any subtotals.

Is this possible?

[Or · Accepted solution]

You can't dynamically enable or disable subtotals, as far as I know. You can use expressions to return null instead of a figure in certain scenarios (e.g. if the first dimension is Dim1, return a subtotal, otherwise return null), using some combination of Dimensionality() and GetObjectDimension() in an If() statement, but the actual row will still be there.

[Qliksense_77]

@Or , thanks:)