7 Replies Latest reply: Jul 5, 2017 10:27 AM by Johann Bauer RSS

    row based calculation of measures

    Johann Bauer

      Hey Guys,

      im facing following problem.

      I have a table with 3 rows and 3 measures. The Dimension KPI has 2 characteristics (EXT/INT) which I can use as a Filter.

      For the calculation of the measures, Im using Set analysis.

      The Customer needs different calculations for the KPI´s.

      For example EBIT and OE should be filtered on the characteristic (EXT/INT) but for the calculation of CR we need the total of this both characteristics, no matter if I select EXT or INT.




      My first thought was to use an IF Statement, like this:


      But the KPI are never explicitly selected, so this is not working for me.


      Can I solve this in the Chart or do I need the change my Script.