Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
To start with I defined a table with the dimension RSS_ANNEE in column:
2017 | 2016 | 2015 | 2014 |
---|---|---|---|
100 | 30 | 35 | 40 |
Now I want to replace RSS_ANNEE by a calculated dimension to show the greatest and smallest selected years in the RSS_ANNEE dimension, and the delta between the two years.
Expected result if 2017, 2016, 2015 are selected in RSS_ANNEE:
2017 | 2015 | Delta |
---|---|---|
100 | 35 | 65 |
To achieve that I declare a Master Dimension MyDim =ValueList($(=Max( RSS_ANNEE)),$(=Min( RSS_ANNEE )),$(=Max( RSS_ANNEE))-$(=Min( RSS_ANNEE )))
I get (with 2017, 2016, 2015 selected in RSS_ANNEE):
2017 | 2015 | 2 |
---|---|---|
165 | 165 | 165 |
The result shows the agregation of the 3 selected years on the 3 columns of MyDim. I understand there is no relationship between MyDim and RSS_ANNEE and MyDim formula was only used to calcule the columns titles.
I could get the expected result by defining 3 measures, but the real table has 3 sub-columns for each year, so I would need to define 9 measures?
That's why I would rather define a calculated dimension if this is possible.
Thanks!
I'd define the 9 measures.
It does not take long to define 9 measures, and it will be a lot, lot quicker to do this than spend ages & ages trying to do it via a Calculated Dimension - Especially as I doubt it is possible.