6 Replies Latest reply on May 27, 2015 10:16 AM by Joe Oppelt

    Change formatting with parameter, and > Parameter flag (WB attached)

    Chaan Thomas



      I have two questions:


      #1. I want to know if it's possible to change the formatting (both color and/or number formatting) when a parameter is toggled.


      In the attached WB I have a parameter that toggles between Sales and item price. The Sales # should be formatted with a "$" and have two decimal places whereas I'd like the item price to have no decimals and no "$" (if I were actually using this data they'd both be dollar amounts of course)


      Also I'd like to know if there's a way to change the color formatting, so if Sales ranges from light green to dark green, I'd like Item price to range form light red to dark red.


      #2. I'd like to know if there's a way to make a parameter that when selected will only show sales > 1,000,000. Of course I could do this with a simple filter and the user could manually type in the amount, but I want a parameter that will toggle On/Off the sales amounts when the user selects it.