I have a cube with 3 dimensions. I have 1 year worth of Data in the cube. yr 2003
2. Time (Yr , Qtr, Month)
3. Measures [ # of Items Sold - Src Measure, Avg # of Items Sold - Calculated]
I have problem in my calculation. The formulae is as follows.
Avg # of Items Sold = [Measures].# of Items Sold / [Time].[Month].Members.Count
When i select the whole year, the formulae works good. It divides the [# of Items Sold] by 12 (Total no of months in the year)
When i select Quarter 1 or Quarter 2 it still divides the [# of Items Sold] by12 instead of 3. Looks like it is acting like a static formulae instead of resolving itself to the number of months in the selected quarter.
Can some body help with the formulae?