0 Replies Latest reply on Nov 21, 2018 3:06 PM by Ellen Yeung

    End-User Selects Sort By and Top N

    Ellen Yeung



      I'm stuck on this and would appreciate some help.


      Must Haves:

      •    The End-User can select whether to Sort the Grand Total by Ascending or Descending per region.
      •    The end-user can select what the Top or Bottom N should be, e.g. Top 5 or Bottom 10, etc.
      •    Do not list the same State in separate rows.



      •   Show the Ranking
      •   Show the Grand Total


      I'd also like the end user to select what the metric is too (not just Profit, but also Sales, etc.  but I think once the above is solved, I can create a separate calculated field on my own.)


      Attached is a workbook with Superstore data.