Sales by Year along top of chart

[#1]

I'd like to show sales by supplier by year. Currently have 3 columns in my chart :

Supplier : Year : Total Sales

However I'd like to see it so the sales are by year per exampled attached so the years appear in separate columns.

Thanks in advance

[robert_mika]

Did you try Pivot Table or generic before Load statement?

Could you share your data?

[alexandros17 · Accepted solution]

Use a pivot table (In charts), first dimension Supplier, second dimensio Year, expression= Sum(Sales)

then click on the year column header and drag to the roght upper of the chart until the blue line that appears became horizontal

Let me know

[#4]

Alessandro - That worked perfectly. I did something similar a while ago but couldnt quite figure out where to drag the year out.

Thanks