Does anyone know how this problem can be overcome?
Thank you for your solution. This definitely provides the solution to the problem I posed.
Unfortunately I simplified the problem a little too much. In reality I will have more products and I just need to total the sales for the top 2 products in each store.
Your solution removes the product with the lowest sales. Do you know how I can retain the sales for the 2 products with the highest sales in each shop?
I have attached an updated workbook which has 4 products. Hopefully any solution which works for 4 products can work for any number of products.
Query - Updated.twbx 63.4 KB
Thank you so much for your help.
I completely forgot about the reference line so it is great to be reminded of this to use for the total label (although, unfortunately, they still come with the horrible tooltips!)
The bars are still separate which is what I had in my original version. I was hoping for one bar for each shop but it looks like this may not be possible. Multiple bars may cause some confusion to the end user if they hover over them.
Definitely an improvement on my initial approach though so thanks again.
All the best