I have a scenario where the count of dimension values need to be used in the calculation.
Lets have 2 dimensions
Dim_SalesGroup and Dim_Product. And, I have one measure as Count of Items Sold as MEAS_CNT.
Now, I need to create a calculted member which should satisfies the follwing calculation
MEAS_CNT / (Count of Dimension members in Axis)
If we slice with Dim_SalesGroup then it should be like
MEAS_CNT / (Count of Dimension members in Dim_SalesGroup)
If we slice with Dim_Product then it should be like
MEAS_CNT / (Count of Dimension members in Dim_Product).
Please suggest me some calculation.
Thanks in advance.
View Complete Post