View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default cumulative total in pivot

I have three columns: account, year, amount. The data is sorted by account
and year. I want a pivot table that has account as row headings and year as
column headings. But instead of a straight sum I want the cumulative
sum...based on years. Is it possible to do it in a single "step"?