Data From Pivot Table

[Balendra Kumar]

Hi

I need help on the following

I have trying to Extract Data from a pivot table based on following

1 . The Data extracted should be based Input selected on Drobdown menu

2. The Data populated should be only for Top Five Item from Value Field

3. Based on the Top five value the selected from the Value Field I should be able to get the Row Labals

4 The Excel formulas should be used for this

Request your help on this

Regards
Balendra