I have a workbook in which I have 2 filters, Dealer Name and Serial No.
Dealer Name is a single value list.
Based on the dealer name selected, I want to show that serial no which the dealer has ordered maximum times
Eg for Dealer D 100, the serial no ak101 appears 3 times and serial no ak102 appears 2 times.
So since count of ak101 is greater than count of ak102 for dealer D 100, I should get the serial no filter preselected to value : 'ak101' for dealer D 100
This is a little tricky but looks possible as I saw this on one of the blogs(link below). What I want to achieve is slightly different than what is shown here.
All excel and twbx files can be found here
Check out the newly released 2018.1 version of Tableau with Hierarchy Filters as an option. - https://onlinehelp.tableau.com/v2018.1/pro/desktop/en-us/help.htm#whatsnew_desktop.html?Highlight=hierarchy%20filter
I think this might address what you would like to do.