Formatting rows by grouping

You can create a conditional column to look for your categories in the other column (this is dummy data)

Then use the matrix visual to achieve what you need (put category and stuff in the rows)

Hi  Anonymous ,

I created some data:

Here are the steps you can follow：

1. Create calculated table.

Table 2 =
var _sum=
SUMMARIZE(
    'Table',
    "MANUAL SHAVE","A",
    "Sales",CALCULATE(SUM('Table'[Sales]),FILTER(ALL('Table'),CONTAINSSTRING('Table'[MANUAL SHAVE],"A"))))
return
UNION('Table',_sum)

Table 3 =
var _sum=
SUMMARIZE(
    'Table',
    "MANUAL SHAVE","B",
    "Sales",CALCULATE(SUM('Table'[Sales]),FILTER(ALL('Table'),CONTAINSSTRING('Table'[MANUAL SHAVE],"B"))))
return
UNION('Table 2',_sum)

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly