Thanks, Nitish Pamarty.
But that will limited the amount of data deploy on all the 7 charts. (I'm not looking to filter the data,I just want to filter what I see in the view detail section)
I need that only be applicable to the view detail section.
I got by doing Top 400 only in the view detail sheet
There are few options where you can apply Top N rule to this worksheet only or to all related sources. Make sure you bring your desired dimension into Filter box that depends on Top N parameter (in my case I sorted top N for customers by sales thus I used Customers in filter and checked Only This Worksheet option). Look below for two different options as the example.
Applied Top N to Sheet 1 (Only This Worksheet checked)
I have another sheet with the same view in one dashboard:
As you can see if you check Only This Worksheet it will apply to that sheet only not every sheet. Now look at another option where I click other options, say Apply to Worksheet / All related data sources then it will apply to all sheets that have related data sources as below:
Then you see it applies to all sheet:
I hope it helps to solve your problem. Please let me know if you don't get the result. Thanks