Conditional Formatting for Totals column

[Anonymous]

Hi all,

As you can see in the image below I used conditional formatting to show all the values that low than 5% (I have two measures).

But, I want to use this condition only on the Totals column.

How do I do this?

My condition is:   if( [%_Re_Reviewed] < 0.05 , yellow())

[Quy_Nguyen]

Hi Itamar,

Use Dimensionality()=0 in the background condition.

Ex:

If(Dimensionality()=0,

If( [YourMeasure]  < 0.05 ,Yellow()))

[Anonymous]

Sorry, it doesn't work.

[cbushey1]

Maybe your total line isnt dimension 0. Try adding a column of dimensionality() and see what appears for the totals row. Then adjust the formula Quy mentioned by this number and it should work fine.

[Anonymous]

Thanks, it works!