Using running sum

Wolfrm

I have a table that has months as columns, and the years (past 5 years) as rows.

I would like the table to display the running sum after each month. It should do this for each of the five years, and of course the rows (years) should be independent of each other. Grateful for any help you can provide.

Thomas Dodds

Works in pivot too ... the sample I have doesn't have the month number by itself, so the pivot isn't the way to show it, but I'm assuming your year is YYYY and your month is MM only.

Wolfrm

Thanks for this example, Thomas, however I would need the months to be columns, not rows. This is so I can visually compare March this year, to March of last year, for example.

Something like this:

My database also has the months in YYYY/MM format, so I have to do some conversions to get it to display as above.

choracy69

Hi Wolfrm,

If youwant compare for example March for each year you can create something like that:

First table it's simple pivot table with row and column grand total. The measure column i RSUM(allocated_hours).

The second table it's simple pivot with 2014,2015,2016 and simple measure column (without RSUM) and Calculated Item: test.

For this you must creation Selection Step:

 

Gianni Ceresa

Take what Thomas did, use a pivot view instead of table, add months as columns and keep years as rows => done

Thomas Dodds

"Works in pivot too ... the sample I have doesn't have the month number by itself, so the pivot isn't the way to show it," ...