cumulative total in pivot

S

Steve

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countif or sumif for cumulative sums,pivot table & chart 2
How do I perform extended calculations in a Pivot Table in Excel 2 4
cumulative total 1
Headings for Sum in Pivot Table. 5
Calculating total amount in a Pivot Table 1
Pivot table data layout - columns to rows 1
Pivot Table Running Sum % 10
Average of % in pivot table 1

Top