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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.