Multi-field formula tool to create cumulative monthly view?

I have some data with some field groupings and then month fields numbered 1-12 with double data type.

Is there a simple way (maybe multi-field formula) to output the data as cumulative (ie each month adds the previous month's data)? I sort of know how to pivot this and use a multi-row formula which has options for row-1 etc, but I'm assuming there's an easier way without having to pivot first?

thanks

Expression

Accepted answers

binu_acs

@Carluccio555

Carluccio555

Thanks for a screenshot not trying to create a row running total, im trying to do this with columns.

All comments

binu_acs

@Carluccio555

Carluccio555

Thanks for a screenshot not trying to create a row running total, im trying to do this with columns.

caltang

Transpose first, then use @binu_acs ' suggestion to do a Running Total - group by the appropriate dimensions, then it will do a sum for you by the dimensions you grouped / ungrouped. Then use Cross Tab to pivot the data back.

This approach is best because it is dynamic and can ingest new fields coming in. Using a multi-field formula is also great, but you need to account for the new field in the expression - which isn't dynamic anymore.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15874

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703