This is very close! The one portion that isn't quite correct is that points should be, for the Product 2 example,
Customer A: 11, 120
Customer B: 2, 50
So the revenue (y-axis) is the revenue for just that single customer (as opposed to total revenue across all customers).
Your file does get the units correct, but it is now summing all revenue across both customers, whereas I am trying for each customer to have its own revenue on the y-axis. Does that make sense?
So your file shows for Product 2:
Customer A: 11, 170
Customer B: 2, 170
Thank you Manideep-
Thank you I really appreciate the assistance Manideep. And so timely it has been a lot of help
1. How can I learn more about the function you used? I never would have figured that out on my own. Basically what it is called, how to use it, etc.
2. If I would like to never see one or more products in the filter, such as I never want the user to be able to select "Product 2", but I still want Product 2's revenue to be included in the total, is there an easy way to do this? Basically if I just want to "hide" Product 2 in the filter (leaving it unchecked).
Thanks again much Manideep-
1 of 1 people found this helpful
Hello Mark - The filter is only working for Units, so your problem is solved.
Have a look in the following Link
This is called Level of Detail (LOD)
You will get your answer here.
Thank you Manideep!