Hierarchies in Tableau are fairly straightforward and easy; your attachment, not so much. Any chance of reworking it to make a bit more understandable? Thanks,
Note to self: Dude you know the difference between "your" and "you're"! Why do you waste so much time editing your posts? Get it right the first time!
I updated the original post, hopefully it make some sense now!
Two plus years later your solution helped me a ton. Thank you.
The workbook that was attached, looks like its corrupted. Any chance you can upload it again? It would be very helpful for me.
1 of 1 people found this helpful
I'm sorry Harsha - I've tried to upload both the ZIP and the TWBX files but the site is not allowing me to do so. I'm not sure why.
I've attached a screen shot of the directions contained in the file. It is a very simple file, though what it's allowed me to do is pretty darn cool.
Keep in mind that this will solve the counting issue, but it will not solve the overall display issue - that one required a bit of a custom data extraction query. I've attached the query that I built to make my particular dashboard possible.
If you need more details, let me know and I will be happy to explain what the heck I'm doing.