Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Misc
Extract Top 5 value from a pivot table
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Andre C, post: 3288259"] Hello Herbert, Thank you for your file. I learned more about the 2007 pivot table. However, I need a report that will give me the top 3 pages for a series of months. The type of reports i am looking for (based on your example) is TOP PAGE Dec Jan Feb (Reference) Greece 11 14 11 Hungary 26 27 26 Iceland 39 38 40 etc Next to that, a report for the corresponding value TOP PAGE Dec Jan Feb etc (Value) Greece 444 313 290 Hungary 115 136 110 Iceland 430 230 461 etc And finally repeat the report for 2nd and 3rd highest page. I could see using your pivot table, but I imagine having to create as many pivot tables as I have different months. Thanks for your help André [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Misc
Extract Top 5 value from a pivot table
Top