Skip to Content
Sep 11, 2017 at 07:32 AM

BO Analysis Excel Cumulative Sum Columns only


Hi Experts, Is it possible to create a dynamic calculation in analysis for excel such that only columns are summed? For example, I have a data set that is:

Column A: opening balance, Column B: Month 1 movement; Column C: Month 2 movement

I want to be able to sum balance across the columns such that I can see the running total. I tried RMB Add Dynamic Calculation - Accumulative Sum but I get the sum across columns and rows when I do this so can't see the balance by GL account. Can't seem to find any tutorials on how to do this type of thing anywhere so I reach out for any help.