Skip to Content

BO Analysis Excel Running Total

Sep 08, 2017 at 11:01 AM


avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers