cumulative % calculation

[Daniel123]

hi, maybe is simple but somehow can't figure it out. I need to calculate cumulative % from each day as a sum of all previous days.

Example : I have 7 days and each day I get some % of conversion:

Mon 1%.

Tue 2%,

Wed 2%,

Thu 4%,

Fri 15%,

Sat 40%

Sun 30%.

In total 100%.

I need a result table with columns for each day and row with cumulative value

Mon 1%,

Tue 3% (1%+2%)

Wed 5% (1+2+2)

Thu 15% (1+2+2+10)

Fri 30% (1+2+2+10+15)

Sat 70% (1+2+2+10+15+40)

Sun 100% (1+2+2+10+15+40+30)

[cjaneczko · Accepted solution]

One way to do it is to transpose the data then use a multi row formula to add the prior rows value. Then Cross tab the results back. 

[usmanbashir · Accepted solution]

@Daniel123 - See attached workflow.

[abbes_omar_87]

Hello, 

You can use the transpose tool and the running total tool. 

See attached workflow using this tool.

Regards,

[Daniel123]

thanks, both RunningTotal and MultiRow formula works for me.