Hi,
I have a hierarchy in a table with Measure Names/Values and broken down by year.
I am trying to sort these descending by one of the measures [Profit] and as you drill-down in the hierarchy I would like the sort to stay and display/repeat the value in all rows - so not the standard drill down Tableau does and more like a classic excel sheet.
The goal is to show the most profitable [Category/Sub-Category/Manufacturer] combination and allowing the user to drill up and down, and not having it sorted [The most profitable Category/The most profitable Sub-Category in that Category/...etc].
I have attached an example workbook where it is kind of what I want - but I am unable to drill up/down as the computing dimension is not longer in the view when you drill, as well how do I make it compute over 2016/the latest year?
Thank you in advance
Hi,
Thank you for your reply but it is unfortunately not what I am looking for, as the table in the link you attached doesn't collapse.
Thanks
