Let me understand your requirement.
Can you explain what are you trying to build?
What is 5%? is that the 5% customers giving maximum sales?
Hi Jaideep. Thanks for the reply.
5% means, 5% customers giving maximum sales. it is like sum of sales of the the members who will come under the top 5% based on the max sales.
i need to show the Top 5%, Top 10%, Top 25% and Top 50% members spending amount in the graphical view. some what i got the requirement(PFA attached book in the first post).
But here the problem i need to show Member details in the drill down who will come under that Top 5%. it should happen like if you click on specific bar.
but POC is not giving the proper result. it working same like how you mentioned int he above post. that is the problem.
if it not possible in this way can suggest any other way to get this requirement.
I hope requirement is clear now.