2 Replies Latest reply on Feb 4, 2014 1:54 PM by taylor.johnson

    Reference Line Band By Pane

    taylor.johnson

      Hello,

       

      I was able to create a constant band reference line each pane by using a dashboard (by creating 3 sheets and using filters)

       

      I know it is possible to create a constant reference line per pane using the formula below, however how do you create a band reference line per sheet using the same formula?

       

       

      1. CASE [Region] 
      2.  
      3. WHEN "Central" THEN 400000   [Insert max range??]
      4. WHEN "East" THEN 350000   [Insert max range??]
      5. WHEN "South" THEN 425000   [Insert max range??]
      6. WHEN "WEST" THEN 375000   [Insert max range??]
      7. END