Hi Ramkesh,
There are some inbuilt functionlality under Pivot table using which we can
achive the desired result.
Please check the attach spreadhseet in which the result is obtained using
"Calculated Field" option of Pivot Table.
Let me know if you have any questions.
Best Regards,
DILIPandey
O
>>
>> --
>> From: harmeet.hew...@gmail.com
>> Date: Fri, 3 Dec 2010 11:36:59 +1100
>> Subject: Re: $$Excel-Macros$$ Own Formule in Pivot Table
>> To: excel-macros@googlegroups.com
>> CC: sunscel...@gmail.com
>>
>>
&g
Hey, not dumb. Easy mistake to make. I make it all the time. That's probably
why I spotted it.
Regards - Dave.
From: harmeet.hew...@gmail.com
Date: Fri, 3 Dec 2010 19:10:18 +1100
Subject: Re: $$Excel-Macros$$ Own Formule in Pivot Table
To: excel-macros@googlegroups.com
Hi Dave,
Thank
9 +1100
> Subject: Re: $$Excel-Macros$$ Own Formule in Pivot Table
> To: excel-macros@googlegroups.com
> CC: sunscel...@gmail.com
>
>
> here you go
>
> Warm Regards,
>
> Harmeet Singh
> IT Analyst
> McKinsey & Company
> http://www.facebook.com/Harmeeet
>
>
Subject: Re: $$Excel-Macros$$ Own Formule in Pivot Table
To: excel-macros@googlegroups.com
CC: sunscel...@gmail.com
here you go
Warm Regards,
Harmeet Singh
IT Analyst
McKinsey & Company
http://www.facebook.com/Harmeeet
On Thu, Dec 2, 2010 at 11:43 PM, Ramkesh Maurya wrote:
Hi All,
Pl
here you go
Warm Regards,
Harmeet Singh
IT Analyst
McKinsey & Company
http://www.facebook.com/Harmeeet
On Thu, Dec 2, 2010 at 11:43 PM, Ramkesh Maurya wrote:
> Hi All,
>
> Please tell me how i can insert my own formule in Excel. e.g 2 is 5.71% of
> 35 the Grand Total, in next column I want to
Hi All,
Please tell me how i can insert my own formule in Excel. e.g 2 is 5.71% of
35 the Grand Total, in next column I want to sum the percentage of 2(
i.ee5.71) + percentage of 3 (i.e. How much 3 is fraction of 35 ?)
*Item* *Quantity* *Cumuletive Sum* A 2 5.71% B 3 C 4 D 5 E 6 F 7
