1 of 1 people found this helpful
Because of the dimensions you have on your worksheet, one route is a Advanced Comput Using.
If you set the Edit Table Calculation options as in the attached image, I believe you will get the results you are looking for.
What these settings are telling Tableau to do is use Product for partitioning, then SKU and Brand for addressing, and then sort on sum of Sales Units.
This was really helpful
Cool! I'll do this and then filter on rank values (top 5, for example) to get only the Top 5 earning categories per week.