Grouping products by Groups and Subgroups

[Nicky_12345]

Hi, please assist:

I need to create the below table as a Power BI visual:

Would the best way be to create/maintain a data table with 3 columns - Product, Subgroup & Group and then create a relationship between the product field between this new table and my dataset to pull through the relative sales contribution by Group/Subgroup?

[Greg_Deckler]

@Nicky_12345 Difficult to say exactly. Use a Matrix visual, put Product Category and Product columns in your rows. Put your Categories column in your columns. Some measure as Value. Without example source data almost impossible to know exactly.