Total Column

[Dabad]

Hi,

Could someone please tell if there is some way that i can remove column "+45" from my total , and  to put after my total column ?

Thank you in advance,

[Dabad]

Table is - Pivot table

[vinieme12]

You can restrict  the dimension values as below

replace DimensionName with your column dimension name

=Aggr(if(Wildmatch(DimensionName,'+45'),null(),DimensionName),DimensionName)  <<--uncheck Show null values for this calculated dimension

[Dabad]

Hi, 

Thank you for your answer.

I have added expression like you proposed me 

=Aggr(if(Wildmatch([Aging Category],'+45'),null(),[Aging Category]),[Aging Category]) but the value is still included in column total

For example for first line should be 4 074 918 but i still have 5 946 176.

Thank you in advance for your help.

[Dabad]

If I uncheck 'include null values' i will loose completely column '+45', i have to keep it, but to not be included in column 'Total'