I have a pivot table with A to Z Company Names in the columns and Months in the rows. Cell value is the total sales from that company per month.
I can filter columns to see the top 5 grossing companies for the whole year but that's not what I want
I want to be able to filter on top 5 grossing company for each month.
SO I want to see company names A, B, C, D, E that did max sales in Jan
and companies D,E, F, G, H, I that did max sales in Feb