1 of 1 people found this helpful
Create a calculated field called 'highlight' with the following formula
[xyz] > 0
Replacing 'xyz' with whatever your measure is called.
Then put this new field onto the color shelf. You can edit the colors in the report by double clicking the color legend.
awesome! that highlights every measure in that row as well but I can deal with it. Thanks do much for the help!
I just noticed that this adversely affects the subtotals. Certain measures I defined as attributes are now showing up in the subtotal overlapping the subtotals I want. So now there are 2 different numbers on top of each other. You can see the red font is the whole measure row of highlighted font from another row showing up on the subtotal. There should be a number in the 1st field, asterisks for the the 2nd and 3rd fields, a number in the 4th field and a red font "5" in the fifth field. Any suggestions on how to fix this? Thanks!
Subtotal Error.PNG 2.8 KB
Matt, try editing the formula so that it's
SUM( [xyz] ) > 0
Or whatever aggregation you are using for your measure.
After you edit the formula, you will need to remove and then re-add it to the color shelf.
Perfect! That did it! Thanks again!