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.


       

      KPIMeasure1Measure2Measure3
      EBIT12
      CR13
      OE13

       

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

      IF(KPI='CR',Sum({1<....>}Value),Sum({$<....>}Value))

      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.

       

      KR

      Johann