can you attach the sample file On Sat, May 21, 2011 at 1:31 AM, Robert Jacobs <robertjacob...@gmail.com>wrote:
> Thank you in advance, experts!!!!! (also posted on Microsoft Excel > group, but not as many members, nor as many responses as I see here) > > > I have an Excel file with a couple of pivot tables. Everything works > perfectly, but I would like one more piece of functionality, if it's > possible. > My raw data includes 6 columns, which are Cust#, CustName, SalesRep, > InvAmount, InvDate, and CustCategory. When I go to my pivot table, I > have it setup like: > Report Filters: Cust#, CustName, SalesRep, CustCategory > Row Labels: InvDate > Values: Sum of InvAmount > When I apply a filter, such as I display all information regarding > the > SalesRep, the filter works perfectly, showing me only InvDates and > InvAmount sums for that SalesRep. BUT, when I want to apply a second > filter, the filter list itself still contains all Cust#, CustName, > and > CustCategory options for all sales reps. Is it possible to filter > the > list once a filter has been applied, so if I filter down to a single > SalesRep, I only see his/her accounts listed in the other filter > lists? > Man, that was hard to word, and I still don't know if I got it > right... PLEASE HELP if possible!!! Thanks guys!!!!!!!! > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com <http://akoul.blogspot.com/> *akoul*.wordpress.com <http://akoul.wordpress.com/> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> P Before printing, think about the environment. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
