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

    Set Analysis with current selection

    Thomas Karner

      Hi,

       

      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