2 Replies Latest reply on Jul 25, 2014 3:20 PM by Blake Bishop

    Grouping by count of counts

    Blake Bishop

      Consider the following reduced data structure:

      CustomerId ProductType NumberPurchased

      1          Strings     0

      1          Buckets     2

      1          Widgets     6

      1          Thingys     0

      2          Strings     0

      2          Buckets     1

      2          Widgets     1

      2          Thingys     2

      3          Strings     1

      3          Buckets     0

      3          Widgets     0

      3          Thingys     0

      4          Strings     0

      4          Buckets     1

      4          Widgets     7

      4          Thingys     1

       

      My actual data structure has about 200 different product types.

       

      I would like to know how to produce a worksheet showing the number of customers who purchased 0 Strings, 1 String, 2 Strings etc., 0 Buckets, 1 Bucket, etc. I can count total number of purchases by product type (sum(NumberPurchased) on Columns shelf, ProductType on Rows shelf) but I've not yet made the jump to the final version of the analysis. I suspect I need to make some sort of calculated field based on the ProductType....

       

      Thanks!

      Blake