Dax Formula Help! 2 Subcategorys

[SRA007]

Hello everyone,

First time posting here. Here is my dilemma. I am trying to create a report with a data set like what you see below. (all examples)
[TABLE="width: 500"]
<tbody>[TR]
[TD]Company[/TD]
[TD]Brand[/TD]
[TD]Category[/TD]
[TD]Sales[/TD]
[TD]Cat Sales[/TD]
[/TR]
[TR]
[TD]Amazon[/TD]
[TD]Turkey[/TD]
[TD]Meat[/TD]
[TD]50[/TD]
[TD]3000[/TD]
[/TR]
[TR]
[TD]Amazon[/TD]
[TD]Ham[/TD]
[TD]Meat[/TD]
[TD]2000[/TD]
[TD]3000[/TD]
[/TR]
[TR]
[TD]Amazon[/TD]
[TD]Bread[/TD]
[TD]Bread[/TD]
[TD]1500[/TD]
[TD]2000[/TD]
[/TR]
</tbody>[/TABLE]


In my report, I would like to add a slicer, on Brand but not repeat the Cat Sales column. For instance, If I select Turkey I want it to say 50 sales, 3000 cat sales, If I select Ham and Turkey, I would like it to say (50+2000) Sales and 3000 Cat sales since they are in the same category.

Any help would be greatly appreciated, I am able to restructure the data however I see fit.

 

[Craigc3814]

Does it need to be a report or a pivot table? If its a pivot table just set Category above Brand in the Hiearchy and allow uses to click the plus sign to break out subtotals within the pivot table.

It would look like this

Sum of Sales Sum of Cat Sales
Meat 2050 6000
Turkey 50 3000
Ham 2000 3000