View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
 
Posts: 896
Default Extract Top 5 value from a pivot table

Could you provide a sample of your data?

On 23 Kwi, 01:47, Andre C <Andre
wrote:
Hello,

I have a a pivot table listing by country and months of the number of times
a certain internet page has been reviewed.

I would like to have a formula (x5) which would extract the 5 highest pages
viewed for a given month and given country.

I tried the Getpivotdata and sumproduct functions, but I am getting nowhere.

Can you help?

Thank you