Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I would like to have three line charts (seperate graphs), everyone of them should only show the sales of one retailer (Amazon, Walmart or Wayfair).
The tricky part is, I would like to show the top retailer in the first line chart, the second in the second line chart....
So lets say the sales ranking for model A is Wayfair, Walmart, Amazon. The top line chart should dispay the Wayfair data, the second line chart should display the Walmart data...
But if you filter on model C, the Walmart sales should be shown in the top line graphs as it is the retailer with the most sales on this model.
I included an excel data set as example.
Thankjs for your help!
If anyone else is trying to do the same thing, I was able to do it using the function FirstSortedValue
If anyone else is trying to do the same thing, I was able to do it using the function FirstSortedValue