Total in Pivot table

[aheavy95]

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

[vincent_ardiet_]

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))

[Aasir]

Use this part
sum({<Transaction_Type-={'TI'}>} Qty)