5 Replies Latest reply: Aug 18, 2016 7:52 AM by Shazad Nazir RSS

    Expression's value should only take effect with one filter only

    Shazad Nazir

       

      Hi Experts,

      In an application I have different filters but I just want this specific KPI expression to take effect when this filter “FiscalYear” changes elsewise the KPI values shouldn’t take any effect.


      Chart Type: KPI 

      Expression: Sum(Max1099)

      Filter Name in this specific application: FiscalYear


      I would want to have an effect on the value of KPI chart (in a sheet), only when there is any selection in :FiscalYear” else no effect should be taken from any other filter(s).

      Can somebody please help!