2 Replies Latest reply on Jan 5, 2016 5:47 AM by Norbert Maijoor

    Create a category from dimension.

    Anoop C Nair

      Hi,

      Need help on the below situation.

       

      Below is the data I have (REF1). I need to build a report on creating a category (REF2) from this Data (REF1). ROWID is the customer id and Unit id is the units he have. So if a customer has more than one unit ( you can see the ROWID is repeating (103, 107)) I will name it as MULTI and if one unit SINGLE.

      I tried couple of tests but unable to get the desired output (REF3).

      REF1:

      ROWID_OBJECT

      UNIT_ID

      101

      1

      102

      2

      103

      3

      103

      4

      104

      5

      105

      6

      106

      7

      107

      8

      107

      9

      107

      10

      108

      11

      109

      12

      110

      13

       

      REF2:

      ROWID_OBJECT

      BUYER_TYPE

      101

      SINGLE

      102

      SINGLE

      103

      MULTI

      104

      SINGLE

      105

      SINGLE

      106

      SINGLE

      107

      MULTI

      108

      SINGLE

      109

      SINGLE

      110

      SINGLE

       

      REF3:

      Graph / Count I’m Expecting.

      BUYER_TYPE

      COUNT

      SINGLE

      8

      MULTI

      2

       

      Regards,

      Anoop