-
1. Re: Conditional Formatting from MoM results
Hi,
1) Create the following Calculated field "Color Coding"
if ([Sales] - lookup([Sales], -1) >0 then "Green" else "Red" end
2) Drag the "Color Coding" & drag into Colors shelf.
Best Regards
Laxman Kumar
-
2. Re: Conditional Formatting from MoM results
Thank you Laxman for taking a look.
I have a couple follow up questions.
1. This formula applied to all rows in the chart- can I limit it to just one specified row? I would like to only apply to the percentage row.
2. The first month I would like to have no formatting (as of now everything in the first month is showing red) and have the comparison start on the second month
