Pivot tables
in [Programming]
|
From: mws on 20 Apr 2010 06:47 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? -- Mike S
From: mattg on 20 Apr 2010 15:59 By "top 5 issues" do you mean the 5 issues or codes that appear most frequently? "mws" wrote: > 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? > > -- > Mike S
From: Roger Govier on 21 Apr 2010 12:18 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 -- Regards Roger Govier mws wrote: > 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? >
From: Simon Lloyd on 21 Apr 2010 12:49 mws;703676 Wrote: > 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? -- Mike S Couldn't you just do this on the original data page by using autofilters, then filter for the name you want to see and in the id column filter by TOP 10 and change that to 5? -- Simon Lloyd Regards, Simon Lloyd 'Excel Chat' (http://www.thecodecage.com/forumz/chat.php) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?u=1 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=196880 http://www.thecodecage.com/forumz
|
Pages: 1 Prev: Change cell color Next: check Wb is open and copy data to it |