1 Reply Latest reply on Sep 28, 2016 7:44 AM by Shinichiro Murakami

    Sort by Grand Total with Row details

    Ryan Meehan

      Hi all,

       

      I am trying to create a text table with a hierarchy for the rows and the weekdays for the columns. I want to be able to sort (descending) and keep the top 25 by the grand total in each category.

       

      I was thinking I could use the index function, but it doesn't seem that you can use this with grand totals. Has anyone been able to accomplish this?

       

      Please see attached example with the Superstore data. (Tableau 10)