2 Replies Latest reply on Jun 17, 2015 1:44 PM by emilie reimer

    Color by 'Select a Measure' Measure and Parameter

    emilie reimer

      Hello! Tough question here...


      I have a measure that looks like this:


      And a parameter that looks like this:



      On the worksheet the user can toggle the measure to display:


      Right now the color is driven by the 'Select-a-Measure' measure, but I need for it to compare itself to its 'last year' version.  I can create a calculated field for each of the six measures like this:


      If [Revenue] >= [Revenue LY] Then 1 Else -1 End


      But how will I implement this to drive the color card? Another calculated field?  What would the syntax look like?


      Thanks for any help!