I have a set of data for weeks, company names and the amount paid. Each week - several companies make payments with different amounts. I have a bar chart with week/date on X axis and the amount paid on Y-Axis. I also have Company Name on the Color Mark.
What I need is for the chart to display Top 5 companies for each unique week. Right now when I edit Company Name filter by top 5 then I get to see 'TOP 5" Companies for the entire data sets...I need to show top 5 for each week. See below. I want to see Top 5 companies colors for each week.