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)
<tbody>
</tbody>
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.
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)
Company | Brand | Category | Sales | Cat Sales |
Amazon | Turkey | Meat | 50 | 3000 |
Amazon | Ham | Meat | 2000 | 3000 |
Amazon | Bread | Bread | 1500 | 2000 |
<tbody>
</tbody>
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.