Hi, I have the following dimensions:
Market
-East(+)
-Market1(+)
-Market2(+)
-South(+)
-Market3(+)
-Center(+)
....
-West(+)
...
Messure
-Profit
I want to calculate the standart deviation of the profit but only want the consolidated values from East, South, Center, West; I dont want to use every market value.
I don`t want to use the aggr function beacause in the futer I want to do the same analisis with some metrics that comes from a complex calculation from the cube.
Thanks!