2 Replies Latest reply: Dec 19, 2016 3:37 PM by Adriano Casanova RSS

    Set filter value and ignore any other selections...

    Adriano Casanova

      Hi,

       

      Need help in figuring this out.

       

      I have a normal KPI showing the a Sum(value), and what I am trying to do, is set the Sum(Value) to show only for the previous month / current year, but at the same time, ignore if the user changes the Month or Year filter.

      How do I enter the setin the expression to simultaneously "force" month and year, and then tell it to ignore the filters? Is this possible even?

       

      Any suggestions or work around?

       

       

      Cheers.

      Adriano.