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 On Thu, Dec 2, 2010 at 6:13 PM, Ramkesh Maurya <sunscel...@gmail.com> 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 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 G 8 35 > Waiting for reply-- > > Ramkesh > 9990260398 > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 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 > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
Own Formula in Pivot - by DILIPandey.xls
Description: MS-Excel spreadsheet
