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.
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
EASy Dashboardv4.twbx 1.6 MB