ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   cumulative total in pivot (https://www.excelbanter.com/excel-discussion-misc-queries/217518-cumulative-total-pivot.html)

Steve

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"?


All times are GMT +1. The time now is 07:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com