Hi, I've been struggling with this issue for two days and I simply cannot find a solution online. I have two different .xls files, one contains Customer-data, and the other sales-data. I would like to showcase The top 5 customers and the top 5 products those individual customers order. The orders should be on a "$" scale and not number of items. So Ideally the customer and their 5 respective top products should be on the X axis, and $ on the Y axis.
If it's one chart per customer and their top 5 products, or one chart for all customers does not matter. How do I go about this?
I think the easiest way is to do a Treemap char, adding Customer and Item as dimension, SUM(Sales Amount) as Measure and setting at the dimensiones Limit Top 5 by the measure.
