Accumulation in Pivot

[kevbrown]

I'm looking to create a pivot table over months that sums a field called "ukmpsmr_risk_prem_by_uw.PBU_NET_USD" to create an accumulation.

Easy?

[arulsettu]

hi

check this thread

Accumulation for Pivot Table

[arulsettu]

rangesum(above(sum(ukmpsmr_risk_prem_by_uw.PBU_NET_USD), 0 , RowNo())))

like this

[kevbrown]

That works if I have Month as rows but i want Month as column headers.

[arulsettu · Accepted solution]

instead of above try before

[kevbrown]

Superb and changing RowNo to ColumnNo it's worked a treat, thanks

[kevbrown]

This is a really stupid question I'm sure, but I require a total column too (which i know will be the same as the most recent date but I'm being asked for it). Surely i can add total to a pivot?