Please help me on below problem. Thanks On Mon, Jul 16, 2012 at 6:29 PM, Mangesh Vimay <mangesh.da...@gmail.com>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:24 PM, Mangesh Vimay <mangesh.da...@gmail.com>wrote:
>
>> Thanks a ton !!!
>>
>>
>> On Mon, Jul 16, 2012 at 6:21 PM, NOORAIN ANSARI <noorain.ans...@gmail.com
>> > 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 Mon, Jul 16, 2012 at 5:37 PM, Mangesh Vimay
>>> <mangesh.da...@gmail.com>wrote:
>>>
>>>> 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. Sorry to trouble u again and again.
>>>>
>>>>
>>>>
>>>> On Mon, Jul 16, 2012 at 5:30 PM, NOORAIN ANSARI <
>>>> noorain.ans...@gmail.com> wrote:
>>>>
>>>>> Dear Mangesh,
>>>>>
>>>>> Please find attached sheet..
>>>>>
>>>>> little correction of Anil's Formula in green part
>>>>>
>>>>> =GETPIVOTDATA("Average of Salary [INR]",$E$1,"Dept",*$E3*)/55
>>>>>
>>>>> Calculated Field solution is also attached here with screen shot.
>>>>>
>>>>>
>>>>> On Mon, Jul 16, 2012 at 5:15 PM, Anil Gawli
>>>>> <gawlianil8...@gmail.com>wrote:
>>>>>
>>>>>> Pls find Attached sheet ...Like this u want?
>>>>>>
>>>>>>
>>>>>> Regards,
>>>>>> Gawli Anil
>>>>>>
>>>>>> On Mon, Jul 16, 2012 at 4:39 PM, Mangesh Vimay <
>>>>>> mangesh.da...@gmail.com> 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+ members already BANNED for violation)
>>>>>>>
>>>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>>>>>> Advice will not get quick attention or may not be answered.
>>>>>>>
>>>>>>> 2) Don't post a question in the thread of another member.
>>>>>>>
>>>>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>>>>> measure.
>>>>>>>
>>>>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>>>>
>>>>>>> 5) Cross-promotion of, or links to, forums competitive to this forum
>>>>>>> in signatures are prohibited.
>>>>>>>
>>>>>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>>>>>> Forum owners and members are not responsible for any loss.
>>>>>>>
>>>>>>>
>>>>>>> ------------------------------------------------------------------------------------------------------
>>>>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>>>>
>>>>>>> To unsubscribe, send a blank email to
>>>>>>> excel-macros+unsubscr...@googlegroups.com
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Thanks & Regards,
>>>>>> Gawli Anil Narayan
>>>>>> Software Developer,
>>>>>> Abacus Software Services Pvt Ltd
>>>>>>
>>>>>> --
>>>>>> FORUM RULES (986+ members already BANNED for violation)
>>>>>>
>>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>>>>> Advice will not get quick attention or may not be answered.
>>>>>>
>>>>>> 2) Don't post a question in the thread of another member.
>>>>>>
>>>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>>>> measure.
>>>>>>
>>>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>>>
>>>>>> 5) Cross-promotion of, or links to, forums competitive to this forum
>>>>>> in signatures are prohibited.
>>>>>>
>>>>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>>>>> Forum owners and members are not responsible for any loss.
>>>>>>
>>>>>>
>>>>>> ------------------------------------------------------------------------------------------------------
>>>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>>>
>>>>>> To unsubscribe, send a blank email to
>>>>>> excel-macros+unsubscr...@googlegroups.com
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> FORUM RULES (986+ members already BANNED for violation)
>>>>>
>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>>>> Advice will not get quick attention or may not be answered.
>>>>>
>>>>> 2) Don't post a question in the thread of another member.
>>>>>
>>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>>> measure.
>>>>>
>>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>>
>>>>> 5) Cross-promotion of, or links to, forums competitive to this forum
>>>>> in signatures are prohibited.
>>>>>
>>>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>>>> Forum owners and members are not responsible for any loss.
>>>>>
>>>>>
>>>>> ------------------------------------------------------------------------------------------------------
>>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>>
>>>>> To unsubscribe, send a blank email to
>>>>> excel-macros+unsubscr...@googlegroups.com
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> 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 Help, Formula Problem, Code Problem, and Need Advice
>>>> will not get quick attention or may not be answered.
>>>>
>>>> 2) Don't post a question in the thread of another member.
>>>>
>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>> measure.
>>>>
>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>
>>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>>> signatures are prohibited.
>>>>
>>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>>> Forum owners and members are not responsible for any loss.
>>>>
>>>>
>>>> ------------------------------------------------------------------------------------------------------
>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>
>>>> To unsubscribe, send a blank email to
>>>> excel-macros+unsubscr...@googlegroups.com
>>>>
>>>
>>>
>>>
>>> --
>>> Thanks & regards,
>>> Noorain Ansari
>>> www.noorainansari.com
>>> www.excelmacroworld.blogspot.com
>>>
>>>
>>>
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> ------------------------------------------------------------------------------------------------------
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>>
>>
>>
>>
>> --
>> With regards,
>>
>> MaNgEsH
>>
>>
>
>
> --
> With regards,
>
> MaNgEsH
>
>
--
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 Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com<<image.png>>
