Dear all group Members, I am also a member of your very good group. I am very pleased to be in this group becasue i have learned a lot of excel from here. i would like to mention that in these days there is no mail i had received that contains attachment file from where i can understand the problem and solution so please i request that do not use personal mails and use group id and post all querries and solution here only so that persons like me those are new to excel can understand the problem and solution. Actually i am new to excel and learning the excel this group helped me a lot to understand new features.
please send all problem and their solution with the attachment file I will be very thankful to the group Thanks Regards LKModi On Mon, Apr 12, 2010 at 7:11 PM, Chaudhry Zahid Ali < chaudhry.zahid....@gmail.com> wrote: > 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 > -- ---------------------------------------------------------------------------------- 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.
