doing this, I only need to get the before total value and put it on the row of beginning balance. is it possible to do that, i mean, the total value will only be located on the row of beginning balance, as the other type, values will be from the database
Say you have two dimensions, Product and month, and one expression, sum(SalesValue), within a pivot table where the second dimension of Month is pivoted so it runs across the top.
I think you can have a test to see if it is ColumnNo(1), and if not then add the contents of before(sum(SalesValue)) to the sum(SalesValue) for the current month that the column relates to. This could look something like this: