To calculate the cumulative total across a row.

[sajal161292]

I have arequirement of computing the cumlative total across a row per different weeks.

Please help me in carrying out the same.

For week 45 it should be 1666.72

For week 46 it should be 1666.72+(-1924.60)+0+0 = -257.88

For week 47 it should be -83.32 +(-257.88) = -341.2

etc.

So at the end it should display the total adding up all of the weeks.

[Abduvali · Accepted solution]

@sajal161292

Are you sure you doing it correctly see my screenshot I have the same layout as your table:

[Abduvali]

Hi @sajal161292,

Try using Matrix table and switch all total ON or they probably switched on by default:

Regards

Abduvali

[sajal161292]

Hi @Abduvali

Thank you for your reply

But i need to add across all the rows.

By switching it ON its adding up only for the columns under it.

While i need to add week 45,46,47 etc.

i.e 1666.72 + (-1924.60 +0 +0 +0)+(-83.32)+ (-130.40) + (-110.82) at the final output.

[Abduvali · Accepted solution]

@sajal161292

Are you sure you doing it correctly see my screenshot I have the same layout as your table:

[sajal161292]

Hi @Abduvali,

It worked for me.I didn't turn the column subtotal.

Thanks fpr your help!!

[v-chuncz-msft · Accepted solution]

@sajal161292,

Since your problem has been resolved, please help accept solution. Your contribution is highly appreciated.