Dear Kumar,

Thank you for your reply.

I followed the same steps as mentioned in the articles shared by you. However, I want to apply one more parameter to the analysis. I want state-wise top 'N' customers. I am attaching the link to the workbook for your reference. Can you please help with this?

https://public.tableau.com/views/TopNcustomerSalesBydynamicvalues_0/TopNcustomerSalesdynamicvalues?:embed=y&:display_cou…

Hi Kumar,

If you open my workbook you can see that I have created a 'State Parameter' and a calculated field 'Select State' basis this parameter. Though I have not added State Parameter card to the sheet but you can see that I have added the calculated field to the filter card. Even if we insert the Parameter card into the sheet and change the state, I am not getting the desired result. (i.e Contribution of top n customers to the sales vis-a-vis others contribution)

Further, I have gone through all the links shared by you. Below article, though rightly gives the top N customers view however it is not fulfilling my requirement. I don't want to show individual customer name and sales contribution. Rather I want to create two groups sales amount of the Top n customers and sales amount of remaining customers in a particular region for a particular period show both groups in the bar chart (like the screenshot I shared the original question).

Top N with multiple dimensions displayed

I hope I am able to clearly mention my requirement. In case, if it still not clear please feel free to ask.