I need to show this data in a Radar Chart, and filter it using a Slicer as such:
When a Slicer filter is clicked such as "3. Processed", the Radar Chart should show how many of each category have the status "3. Processed".
It should display the actual amount (in this case, 1), but also show the total amount of Status for each Category (in this case, 2, since "Drinks" has a total of 2 rows). We should not count distinct rows only, so if there was one more status called "Draft" for "Drinks", then the total would be 3.