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

    End-User Selects Sort By and Top N

    Ellen Yeung

      Hello,

       

      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.

       

      Nice-to-Haves:

      •   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.

      Thanks,

      Ellen