Color the total columns in a Pivot table

[clarachac]

Hello,

How can I add a color to the columns in yellow below (total line and column): 

I know how to color the line, by adding IF(Dimensionality()=0, '#E0E0E0')  in the measure

But what can I add a color the column too? 

Thank you

[TauseefKhan]

To color the total columns Use:

IF(Dimensionality() = 1, '#FFFF00')

[JHuis · Accepted solution]

u can use the new pivot table and style the totals label

[clarachac]

IF(Dimensionality() = 1, '#FFFF00') 
colors all the values of the table, not only the total column 😞

[clarachac]

Hello,

I have a problem with the P&L pivot table, the total doesn't appear :