4 Replies Latest reply on Jan 28, 2019 9:56 PM by Shinichiro Murakami

    Customize group differently for each group

    Ben K

      Hi, I am looking for a solution to group the channels differently.

      The dataset has a hierarchy and just want to see the sales of the product with different channel grouping.

       

      The data has a hierarchy as Product > Channels, and these products have similar channels basically.

       

      Product
      Channel

      201701

      201702
      Bowl

      AB

      CD

      EF

      GH

      Online

      100

      200

      300

      400

      0

      500

      600

      700

      800

      2000

      Ent

      AB

      CD

      EF

      GH

      Online

      900

      1000

      1100

      1200

      0

      1300

      1400

      1500

      1600

      2000

      Equip

      AB

      CD

      EF

      GH

      1700

      1800

      1900

      2000

      500

      600

      700

      800

       

      I expect a table or chart like under:

      ProductChannel201701
      201702

      Bowl

      AB+CD

      EF+GH

      Online

      300 (100+200)

      700 (300+400)

      0

      1100 (500+600)

      1500 (700+800)

      2000

      Ent

      AB+CD+EF+GH

      Online

      4200 (900+1000+1100+1200)

      0

      5800 (1300+1400+1500+1600)

      2000

      EquipAB+CD+EF+GH

      7400 (1700+1800+1900+2000)

      2600 (500+600+700+800)

       

       

      The problem is If I group  AB + CD of Bowl product, it changes to AB + CD for all product.

      But I want to customize the group for each product, which is like the table above, grouping channels differently for each product.

       

      What should I use? functions in the calculated field? set? group? a condition within the channel filter?

      I appreciate you explain your solution to me with the workbook attached. Thank you!