Re: $$Excel-Macros$$ Please solve my Pivot Table Problem

2012-07-17 Thread Venkatesh Narla
Hi, Please find the updated file Thanks, Venkatesh. On Mon, Jul 16, 2012 at 4:39 PM, Mangesh Vimay wrote: > Hi Friends, > > I need your help to solve my PT Problem. > The description is given in sheet itself. Please FA. > > Thanks. > > -- > With regards, > > MaNgEsH > > -- > FORUM RULES (986+

Re: $$Excel-Macros$$ Please solve my Pivot Table Problem

2012-07-17 Thread Mangesh Vimay
Thank you much for kind support. !!! On Tue, Jul 17, 2012 at 11:17 AM, NOORAIN ANSARI wrote: > Dear Mangesh, > > See attached Screen shot. > > > On Mon, Jul 16, 2012 at 9:54 PM, Mangesh Vimay wrote: > >> Please help me on below problem. >> Thanks >> >> >> On Mon, Jul 16, 2012 at 6:29 PM, Manges

Re: $$Excel-Macros$$ Please solve my Pivot Table Problem

2012-07-16 Thread Anil Gawli
goto calculations field, then click on field items and set then click on calculation field then click the dropdown button of Name field and click on delete. Regards, Gawli Anil On Mon, Jul 16, 2012 at 9:54 PM, Mangesh Vimay <> wrote: > Please help me on below problem. > Thanks > > > On Mon, Jul

Re: $$Excel-Macros$$ Please solve my Pivot Table Problem

2012-07-16 Thread Mangesh Vimay
Please help me on below problem. Thanks On Mon, Jul 16, 2012 at 6:29 PM, Mangesh Vimay wrote: > Hi Noorain, > > If I have to delete some fields as below then How could I do this? Like > Salary in Dollar, Field1, Avg Sal in $ > Please help. > [image: Inline image 1] > > > On Mon, Jul 16, 2012 at 6

Re: $$Excel-Macros$$ Please solve my Pivot Table Problem

2012-07-16 Thread Mangesh Vimay
Hi Noorain, If I have to delete some fields as below then How could I do this? Like Salary in Dollar, Field1, Avg Sal in $ Please help. [image: Inline image 1] On Mon, Jul 16, 2012 at 6:24 PM, Mangesh Vimay wrote: > Thanks a ton !!! > > > On Mon, Jul 16, 2012 at 6:21 PM, NOORAIN ANSARI > wrote:

Re: $$Excel-Macros$$ Please solve my Pivot Table Problem

2012-07-16 Thread Mangesh Vimay
Thanks a ton !!! On Mon, Jul 16, 2012 at 6:21 PM, NOORAIN ANSARI wrote: > Dear Manesh, > > As desired, Please find step by step screen shot with complete explanation > as attachment. > > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > On Mo

Re: $$Excel-Macros$$ Please solve my Pivot Table Problem

2012-07-16 Thread Mangesh Vimay
Hi Noorain. Thanks but I do not understand how did you calculated the Average Salary ($) by using *calculated field*. Please provide me documentation so that I could understand. I know it is time consuming job for you and really sorry for that. But I dont have alternative. So please help me dear. S

Re: $$Excel-Macros$$ Please solve my Pivot Table Problem

2012-07-16 Thread Mangesh Vimay
Hi Anil, Thanks lot. But I need to calculate the average($) by using Calculated Field option given in Options ---> Formulas ---> calculated field. Is it possible by using above method. Please let me know. Thanks again. On Mon, Jul 16, 2012 at 5:15 PM, Anil Gawli wrote: > Pls find Attached sheet

Re: $$Excel-Macros$$ Please solve my Pivot Table Problem

2012-07-16 Thread Anil Gawli
Pls find Attached sheet ...Like this u want? Regards, Gawli Anil On Mon, Jul 16, 2012 at 4:39 PM, Mangesh Vimay wrote: > Hi Friends, > > I need your help to solve my PT Problem. > The description is given in sheet itself. Please FA. > > Thanks. > > -- > With regards, > > MaNgEsH > > -- > FORUM

$$Excel-Macros$$ Please solve my Pivot Table Problem

2012-07-16 Thread Mangesh Vimay
Hi Friends, I need your help to solve my PT Problem. The description is given in sheet itself. Please FA. Thanks. -- With regards, MaNgEsH -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need H