Hello.
I would like to group dimension values.
I have a Record, which has multiple products associated to the Record. I need to take a count of the product of the record, however, the product has multiple values which need to be grouped together.
I.E.
Record 1001- They have products
Pizza, Meat pizza, Pies, Meat pies,
(IF Products = pizza or meat pizza then pizza.
if products = pies or meat pies then pies. )
if products = pizza and pies then combined pizzapies.
I have individual tables, record table, product table.
I have the model and its working correctly, just trying to get the grouping of the products,
