Pivot tables

  • Thread starter Thread starter mws
  • Start date Start date
M

mws

Hi , bit of a novice at this and desperately in need of some help.

I have a large worksheet full of data and most of it I can get sorted using
pivot tables but I want to be able to dynamically re-arrange stuff.

let say I have list of accounts, each account has varying number of request
id's associated. Each munth I want to be able to pick from a drop down list a
customers name and see their top 5 issues.

So far all I have been able to do is get their names in order, and i have
also been able to get the drop down list but getting their request list is
not proving to be easy.

Anyone able to hgelp on this?
 
By "top 5 issues" do you mean the 5 issues or codes that appear most
frequently?
 
Hi

Maybe the following would help
Put Account as a Page item
Request Id as a Row item and then click on advanced for Request>click To
10 autoshow>on>Select top 5
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using VBA on Excel Pivot Tables 3
Link Drop Down list with Pivot Table 3
Link Drop Down list with PIVOT Table in Excel 2003 0
Pivot Table Question 2
Pivot table help 6
Changing the CurrentPage items in a Pivot Table 1
Pivot table code question 2
Excel Pivot Table Drop Down Macro 2

Back
Top