This content has been marked as final. Show 7 replies
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.