5 Replies Latest reply on Mar 2, 2012 2:41 PM by Alex Kerin

    How to see how many customers with one sale, how many with two, ...

    Teresa Obis

      I think that will be a simple question, but I can not find the solution now.

       

      I use the SuperStore Sales sample and I can get a sheet with how many recods has every customer (see Sheet 1). The result are

       

      Now I would like to have a report that tell me how many custumer has 1 sale (in the example below 6), how many has 2 sales (17 because the example below is only a partial one, see twbx attached), and go on. Something than:

       

      Number of sales      Number of customers with that number of sales

      1                              6

      2                             17

      3                            ...

       

      Can any of you help me?

       

      Thank you very much,

       

      Teresa