2 Replies Latest reply: Sep 26, 2016 9:38 AM by Sunny Talwar RSS

    Filter Controls using IF statements within a kpi

    buck master

      I want to be able to have the default show if nothing is picked to the current year, with the percentage value showing for the Month of December defaulted. (Should show for example = 2015 - $5,000/ 5%)

       

      if the user picks a Quarter and no month, I want the last month of that Quarter used as a default.

      (Should show for example = 2015 - $3,800/ 4%)

       

      lastly, the user should only be able to pick a month within the Quarter selected. if possible, only one Quarter/Month at a time.