I have read your question and description. I think there is a problem with the action when you click on the others if I am not wrong.
Still if I ask you to frame your question in 1-2 line, how would you do that? What is your expected output?
Ivan Young, please assist on this one.
You are having problems with you top 10 and others calculation. Please find the screenshot below. See for others you are getting level as P.
Also see the underlying data for the same.
Thus when you click on others you are getting only level 2 for P and not for all of the remaining levels. Please change the calculations. I am taking a look at your calcs. Let me see if I can help you with calcs.
Thanks and Regards,
1 of 1 people found this helpful
If you could help me structure my calculation better, that would be much appreciated.