My second favourite challenge in Tableau, after Table Calculations, is anything with Set Actions. Some of you may have already used these in previous challenges this year, but this week I am dedicating it to this wonderful (and sometimes tricky) Tableau functionality.
Warning: this is not a beginner-friendly challenge!
The problem I wanted to solve sounds simple: can I use Set Actions to drill-down by TWO levels in a hierarchy? The answer is Yes!
I have used the familiar Superstore data set to practice drilling down from Category, to Sub-category and then Manufacturer. Good luck!
Create a set based on the other set data is really usefully!