1 2 3 Previous Next 30 Replies Latest reply on Jul 31, 2015 2:39 AM by nick Rao

    Max and min of an aggregate

    Julianna Wokurka

      Attached you'll see an example.

      I grouped all the customers by 25% of total sales.

      So group 1 shows customers for the top 25% of sales.

      Next I have the count of the customers in the top 25% of sales.

      Finally I show the average sales for the customers in the top 25% of sales.

       

      What I'd like to do next if just show the max and min for the customers in each group.

      So for the top 25% of sales, what is the max/min amount a customer spent?

       

      I can't figure out how to do this. Thank you for your assistance.

        1 2 3 Previous Next