Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
I have a question regarding column totals in pivot table.
Might be an odd request but- is there a way to exclude a column value from the column totals, but so it is still included with it's value
In this case, for StoreID 2 , the value 'TI' (in the bottom) of the column Transaction_Type, I want it to be excluded from the column total (-416) but so the value still appears (385)
The 'Qty' measure is a simple: sum(Qty)
Thanks
You can check SecondaryDimensionality or Dimensionality functions, for example something like this (but you need to check I never remember which one to use or which value to test).
=If(SecondaryDimensionality()=0,Sum({<StoreID-={TI}>}Qty),Sum(Qty))
Use this part
sum({<Transaction_Type-={'TI'}>} Qty)