VBA code to display top selected number of rows in pivot table

[vanisree]

Team,

I got a requirement where I have to display top number of suppliers dynamically. The top numbers will be chosen by the manager and I should display the data in pivot table. As my dataset will have more than one supplier spend, I have to use pivot to cumulate the spend.

Do help me to figure this out.

Regards
Vanisree