Hi ,
I have a dimesion having customer information and a fact with sales information. I want to create a calculated member in cube (using calculation tab in SSAS), which will give me top 100 customer according to their total purchase.
Does any one has idea how to get this.
Thanks,