Hi Alisha, Use the 'Running Total in' option in 'Value Field' settings (Go to 'Show Value as' tab) to generate the cumulative sum in pivot table.
________________________________________ Thanks & Regards Ashish Jain (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http://www.excelitems.com http://www.openexcel.com ________________________________________ On Dec 7, 3:36 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
