8 Replies Latest reply: Dec 17, 2017 5:50 AM by Effendi Baba RSS

    Working with set analysis with KPI

    Effendi Baba

      I would like to set my KPI to be based on the latest year when users open up the worksheet. This will have a secondary figure which shows the value of year-1. However, I would like the figure in KPI to change based on user selection. For example it is now 2017.  The sales figure for the sales field should sum up 2017 and show 2016 figure for comparison. If users select 2016 in the filter, the KPI should show 2016 and 2015 figures. How can  accomplish this?

       

      I am starting with this.

      sum( {$<Year = {$(=Only(Year)-1)}>} Sales )

      sum( {$<Year = {$(=Only(Year))}>} Sales )