Apparently, I can't get Tableau to follow the supposed Order of Operations, which indicates that the filters are applied in the following structure:
Extract Filters > Data Source Filters > Context Filters > Set Filters
It's when I apply Set Filters that my workbook gets messed up:
I have a table (sorry for the format - it's directed from levels way above mine), that follows below structure:
Context Filter: [Customer Name]
Set Filter: [Top 5 Sub-Categories per Sales]
So I am expecting that when the user filters by [Customer], the table will show the Top 5 sub-categories for the selected customer, with the Sales for each State.
However, the Set filter seems to be being applied first, as each customer gets only 1 brand (if any) and even the states get filtered.
I might've interpreted this differently but if there so sale associated for a customer with State or Sub-Category it wouldn't show up in Top N right? Tableau only shows where there is a value present.
So for example, you'd only see 3 columns and 3 states for Aaron Bergman like so although you have Top 5 filter,
Was this your question?
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...