Please see revised worksheet

Hello Mitul,

The purpose of using Pivot Table is to structure the data as you want to present it, often by using graphs.
Due to the layout of the table you have created there is no easy way to continue with your approach. Either you continue as you have started, but you will not have any dynamic update in your list of maximum sales per month and year.

In attached file I have copied your Pivot Table to another sheet, named MaxSales. I re-arranged the Pivot Table so it gives (in my opinion) a better view of what I want to show, namely which salesperson who sold the most per device, month and year. Whenever I add more data this Pivot Table will be updated accordingly, no need for manual extra work. For extra visibility I also added a formatting rule so that the maximum sales is highlighted in green.

If you want to continue create a separate list, then I suggest you don't use the Pivot Table as the data source for your lookups, better then to use the raw data. I know this is not an answer to your question, rather an example of how you can use another approach to achieve the same.

Br,
Anders

Hello Mitul,

Please refer to  https://www.myonlinetraininghub.com/excel-getpivotdata-function to learn more of how to use GetPivotData function.

Br,
Anders

                Thank you very much, Anders (my friend)

                I  did not thought about Timeline feature , and I  learned  formatting rule feature.

                       Once again, I  appreciate it very much.