Hi, File by Mr Kantilal Badale is working as per your requirements. In case you find problem in understanding how it is working please click on any cell in column marked Sum of Sale 2 and right click. Select "Value Field Setting.." > Select summarize by Sum and in Show Value as tab select Running total in and Base Value: Qtr.
Hope that helps, Anand On Dec 9, 5:26 am, Kantilal Badale <kantilal.bad...@gmail.com> wrote: > check the attachment see if it helps . > > Kantilal Badale > > On Tue, Dec 7, 2010 at 4:06 PM, alisha malhotra <alisha.malhotr...@gmail.com > > > > > > > > > wrote: > > Hi Group, > > > I have one pivot table. In that I want to show the cumulative sum. > > e.g. > > Qtr1 sale:- 10 units > > Qtr2 sale:- 20 units > > Qtr3 sale:- 10 units > > Qtr4 sale:- 30 units > > now i want to show the sale of qtr1 and qtr2 i.e. 30 units after qtr2 and > > similarly after qtr3 cumulative sum of qtr1,2 and 3 i.e. 40 units and so > > on. > > > How can I do this? Can anyone help me please? > > > Thanks & Regards, > > Alisha malhotra > > > -- > > > --------------------------------------------------------------------------- > > ------- > > 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 athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://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&;... > > > > Cumulative sum in pivot.xlsx > 15KViewDownload -- ---------------------------------------------------------------------------------- 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
