Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
If I have a measure as a master item called (Country missing) and I have used this as a measure in my pivot table, how do I ensure that the if this measure is greater than 0 the text in the pivot table is red and green if not ?
Go to your measure in the pivot table options, and edit the text color expression to something like
If([Measure] > 0, red(), green())
Go to your measure in the pivot table options, and edit the text color expression to something like
If([Measure] > 0, red(), green())
Click the plus by the dimension or expression (depending on what you want to be green). Then double click on the "Text color" and type this:
if(Measure > 0,RGB(0,128,0),
RGB(230,0,0))