Display The Count of Students only for partiular dimensions

[#1]

Hi All,

I have Year, Country,State ,Stage & Band as my selections . But I have to count the No. of Customers only at Stage & Band Level . wat I mean is I want to see overall customers when I clik on Year,Country & State(The count of customers should not change wen i select Year , Country & State ). But when I select Stage & Band the count of customers has to be shown accordingly .

Please help me to achieve the above .

Thx in Advance.

Regards,

MS

[#2]

You can use set analysis in your expression and ignore the Year, Country and State. Use the following expression:

=count({<Year=,Country=,State=>Customers}

This should resolve your problem.

-Haneesh

[#3]

Try this create a table having Stage & Band as dimension & count({1} Customer) as expression.

[#4]

Thanks Haneesh for your reply .

But I have a cocern here i.e. I have many years , State and Country and I can't hard code the values .

Please use the same example u sent, and let me know how to specify not equal to null in set analysis

[#5]

Thanks for your replay santhosh ,

The expression which u suggested will not work for any selection . But I dont want that .

I want the values to be changed for stage .........

[#6]

Thanks for your help . Luckly I got it .