I'm totally lost on this one. I'm trying to create multiple expressions to stack in a bar chart that sum up volume for products with the following criteria:
1. Sum of volume for products that are sourced by 1 Supplier within the quarter
2. Sum of volume for products that are sourced by 2 different Suppliers within the quarter
3. Sum of volume for products that are sourced by 3 or more different Suppliers within the quarter
Here's what I have so far for #2 for example:
=if(Count(DISTINCT SUPPLIER = 2), Sum(VOLUME))
What I still need: this count should be by <Quarter> and by <Product>, I don't know how to integrate those two things into this formula.
Please help, thank you!!!
Susan