Hi, You can check out the below links for examples http://office.microsoft.com/en-gb/excel-help/create-your-own-formula-in-a-pivottable-or-pivotchart-report-HP005199482.aspx http://www.contextures.com/excel-pivot-table-calculated-field.html
On Wed, Apr 11, 2012 at 3:32 PM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > Dear Shaik Waheed, > > I am unable to put any formula in the pivot table. > > Please help. > > Thanking you in advance > > Regards > > Sanjib > - Show quoted text - > > > On Wed, Apr 11, 2012 at 3:13 PM, Shaik Waheed <waheedb...@gmail.com>wrote: > >> One more thing, i have observed that the amount total is not matching for >> this u need to enter the "S" amount in positive only...the formula then >> calcuates. >> " >> >> On Wed, Apr 11, 2012 at 3:10 PM, Shaik Waheed <waheedb...@gmail.com>wrote: >> >>> Sanjib, >>> >>> Click on the pivot, on the toolbar, click on options --- >Formulas ---> >>> list of formulas ---> there u can see i have added a formual "Net Quantity" >>> = B- S. >>> >>> To add a formula u need to click on the items in the pivot >>> -->Toolbar(above) --> formulas--> Calculate Item---> u can enter the >>> required formula.. >>> >>> Hope i explained it... >>> >>> >>> >>> On Wed, Apr 11, 2012 at 2:41 PM, Sanjib Chatterjee < >>> chatterjee.kolk...@gmail.com> wrote: >>> >>>> explain only the highlighted portion >>>> >>>> thanking you in Advance >>>> >>>> Regards, >>>> >>>> Sanjib >>>> >>>> >>>> >>>> On Wed, Apr 11, 2012 at 2:34 PM, Sanjib Chatterjee < >>>> chatterjee.kolk...@gmail.com> wrote: >>>> >>>>> yes, This is is excetly what I am looking for. >>>>> would you explain please. >>>>> >>>>> regards, >>>>> >>>>> sanjib >>>>> >>>>> >>>>> On Wed, Apr 11, 2012 at 12:45 PM, Shaik Waheed >>>>> <waheedb...@gmail.com>wrote: >>>>> >>>>>> Hi Sanjib, >>>>>> >>>>>> PFA check sheet 2. Hope this helps >>>>>> >>>>>> On Wed, Apr 11, 2012 at 10:54 AM, Sanjib Chatterjee < >>>>>> chatterjee.kolk...@gmail.com> wrote: >>>>>> >>>>>>> >>>>>>> Dear Sir, >>>>>>> >>>>>>> Your work is really great and appreciable, But I have given you >>>>>>> only 4 or 5 scripts. There could have been more than 1500+ scripts. In >>>>>>> that case pivot table is excellent. So is there >>>>>>> any option to do the task with the help of pivot table? >>>>>>> >>>>>>> Thanking you in Advance. >>>>>>> >>>>>>> Regards, >>>>>>> >>>>>>> Sanjib >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> ---------- Forwarded message ---------- >>>>>>> From: Shaik Waheed <waheedb...@gmail.com> >>>>>>> Date: Tue, Apr 10, 2012 at 7:06 PM >>>>>>> Subject: Re: $$Excel-Macros$$ regarding pivot table problem >>>>>>> To: excel-macros@googlegroups.com >>>>>>> >>>>>>> >>>>>>> Hi Sanjib, >>>>>>> >>>>>>> PFA, is it this you want? I had just given a try.... >>>>>>> >>>>>>> On Mon, Apr 9, 2012 at 5:36 PM, Sanjib Chatterjee < >>>>>>> chatterjee.kolk...@gmail.com> wrote: >>>>>>> >>>>>>>> Dear Mr. Sourbh Salgotra, >>>>>>>> >>>>>>>> I am already done it please check my attachment.. But I want >>>>>>>> rather differently which >>>>>>>> I mentioned. >>>>>>>> >>>>>>>> Thanking you >>>>>>>> >>>>>>>> Sanjib >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> On Mon, Apr 9, 2012 at 5:28 PM, Sourabh Salgotra < >>>>>>>> rhtdmja...@gmail.com> wrote: >>>>>>>> >>>>>>>>> plz check attachement >>>>>>>>> >>>>>>>>> On Mon, Apr 9, 2012 at 4:48 PM, Sanjib Chatterjee < >>>>>>>>> chatterjee.kolk...@gmail.com> wrote: >>>>>>>>> >>>>>>>>>> >>>>>>>>>> Dear Sir, >>>>>>>>>> previously i sent you the mail. But I got the error message that >>>>>>>>>> the message I am sending >>>>>>>>>> is cross the allocated limit so I am sending you the fresh >>>>>>>>>> message. >>>>>>>>>> >>>>>>>>>> Please see the attachment. I have created the Pivot table based >>>>>>>>>> on the data of sheet1. Then >>>>>>>>>> follow the step for creating pivot table. But I want in same >>>>>>>>>> different format. In BS column >>>>>>>>>> referred to buy and sale of scripts. If there is B in the column >>>>>>>>>> then quantity should be put >>>>>>>>>> as buy qty and next buy rate. If there is S in the column then >>>>>>>>>> quantity should be put as >>>>>>>>>> sale and next sale rate. Net qty should be buy - sale quantity. >>>>>>>>>> >>>>>>>>>> Please help to solve the problem >>>>>>>>>> >>>>>>>>>> Thanking you in Advance. >>>>>>>>>> >>>>>>>>>> Sanjib >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> -- >>>>>>>>>> - >>>>>>>>>> >>>>>>>>>> -- >>>>>>>>>> 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 >>>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> -- >>>>>>>>> mujhay dukh is baat ka nahin kay meri zaat ko >>>>>>>>> muntashir karny walay haath tairy thy >>>>>>>>> mujhay dukh faqt is baat ka hay meri raiza raiza zaat ko >>>>>>>>> samaitnay walay haath tairy na thy >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> -------------------------------------------------------------------------------- >>>>>>>>> >>>>>>>>> >>>>>>>>> Thanks & Regards >>>>>>>>> Sourabh >>>>>>>>> Contact Numbers: +91-94630-49202 >>>>>>>>> Website:http://adhurapyaar.co.cc >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> -- >>>>>>>>> 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 >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> - >>>>>>>> >>>>>>>> -- >>>>>>>> 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 >>>>>>>> >>>>>>> >>>>>>> -- >>>>>>> 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 >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> - >>>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> - >>>>> >>>> >>>> >>>> >>>> -- >>>> - >>>> >>> >>> >> -- >> 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 >> > > > > -- > - > -- 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
