How to remove background color in Pivot table Total?

[sergio0592]

Hi all,

I have a pivot table with conditionnal color in body chart. On the right, i have a total column (snapshot below). I can't manage remove the color of this column. Any idea? Thanks

[marcus_sommer · Accepted solution]

They might be created per the tab visualization within the document properties or per custom cell format (right click on the column) or with an attribute expression - the last method is usually the most suitable one because it's more flexible as the other ones (an here you may query the seconddimensionality() to format the totals differently to the normal results).

- Marcus

[sergio0592]

Thanks. it works with Secondarydimensionality()