If I have a data set w/ values for different product costs, per year, how do you adjust individual columns in a pivot chart so that the largest values "per year" are in descending order of each column, not "per product"? The problem im running into is that the product with the largest "combined year value" is applied to the top of "year" columns even though it isnt the largest value for a specific year. I want to be able to adjust just the individual columns.

I already know how to create pivot tables and charts for the most part so no need to explain much there. Just need help with the problem at hand.