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 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 > -- ---------------------------------------------------------------------------------- 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
Cumulative sum in pivot.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
