5 Replies Latest reply: Jun 13, 2018 5:04 AM by Sunny Talwar RSS

    Set Analysis with current selection

    Thomas Karner



      I´m using a KPI expression for a chart like

      Sum( {<Status={'A', 'B'}>} CountOffers)


      The same set analysis expression is used in all chart objects of the sheet for other KPIs.


      If a user selects status = A this selection should be used in the KPI expression. But this is not the case when I use the expression above, because the selection on status is fixed to A+B, disregarding the current selection of the user.


      What is the easiest way to solve this?


      KR, Thomas