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.
How to dynamically set default values for quick filters | Tableau Software
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.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...