Forum Discussion

kylesmyle's avatar
kylesmyle
Frequent Visitor
2 years ago
Solved

Group Two Products

I'm just looking to combine/group Product A and F. This would then give me a new product with their combined values. Is this possible?
  • parry2k's avatar
    2 years ago

    kylesmyle you need to add a new column and then use that on the row:

     

    New Product Column = 
    IF ( Table[Product] IN { "Product A", "Product F" }, "Product A & F", Table[Product] )