1 Reply Latest reply on Apr 9, 2013 11:47 AM by Joshua Milligan

    grouping when multiple dimensions are indicated in each row

    David Giller

      Hi,

       

      I would like to ask if anyone knows how to create groups where a row with multiple classifications is counted in each separate classification (I know this would be double counting but this is what I want).  Right now in the workbook things are classified as "Multiple"

       

      I have attached a workbook, but have also included an example below...

       

      Customer Name          Languages

      a                                   PHP

      b                                   PHP, Java, Python

      c                                   Java, Python

       

      I would like to create groups where the PHP bucket count is 2 (a&b), the Java bucket count is 2 (b&c), the Python bucket count is 2 (b&c)