The approach I typically take in this case is to create two separate calculated fields which surface the sales value only for the members in each group, and NULL otherwise.
[Sales of Coffee] :=
IF [Product]="French Roast" OR [Product]="Vanilla" OR [Product]="Hazelnut" OR [Product]="Iced Coffee"
[Sales of Cold Drinks] :=
IF [Product]="Soda" OR [Product]="Sports Drink" OR [Product]="Iced Coffee"
Once you've created those two calculated fields, place them both on your viz to compare sales in each group.
I hope this helps,
Thanks for the response. Unfortunately, this does still not solve my issue. The method you have suggested (I changed a couple things to fit my needs) provides the information split into 4 rows:
Using this you can come up with the correct sales number for each one, but I am looking for a more efficient method:
Sales of Coffee: 192,083 + 18,257 = 210,340
Sales of Cold Drinks: 16,857 + 18,257 = 35,114
I need it to display something like this (with the correct sales numbers):
As you can see the 'Sales of Cold Drinks" value exlcudes the values that overlap which account for the 18,257
Any other thoughts?