Hello Group, *Overview:* I have a issue to discuss. I have got an excel sheet which contains over 150,000 trial balance account subheads made up of data from different branches (All Branches). So there are multiple account heads that are repeating. I have constructed a Pivot table out of the data which on application of a filter gives me NP and Sales amount for different types (Huge, Big, Medium, Small) of branches.
*Required:* Now what I want to do is to apply two different filters on two different columns which fall under the same Pivot table. Is it possible, or am I asking too much from excel. I know I can construct a seperate table for both NP and sales, but the issue is I am trying to automate the process and if I make seperate account heads for seperate files, well, I will be ending up making atleast 50 Pivot tables in a file which has already crossed 200 MB. *In Short:* *HELP* ** Thanks...... -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using "remove me" as the subject.
