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,
Table is - Pivot table
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
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.
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'