i have a lot of stocks with info like GRN date, qty, value, lead time etc.

I used pivot table to consolidate as some items has a few lines because of
different GRN dates. (GRN=good received note)

- how can the pivot table display the top 10 highest value stocks? If
unable, at least display by descending order
- anyway to stop the 'lead time' cell going blank?

thks