Hi,

I am have the Hierarchy Year <- Quarter <- Month, I am trying to get current year's, current quarter's, month's,  sales amount using level.CURRENTMEMBER function.

But every time when I try to get I am getting the [ALL] member only.

Ex: [Level Year].currentmember, [Level Quarter].currentmember, [Level Month].currentmember every time it is giving [ALL] member's measure value.

I want to get the current year = 2010, current quarter = 3, current month= september 's measures values only.

Can any one help me about my request.

Thanks in advance.

Chetan