Get top 10 records in excel pivot table..?

Question

Hi Frnds,

 

   I am creating chart using pivot table in excel, in pivot table having 20 records (Sno, Value) columns, if all the value column having same value i am not able to get top 10 rows , it will bring all the 20 records. 

 

How to get only top 10 records.??

 

Thanks in Advace.