4 Replies Latest reply on Mar 21, 2017 3:58 PM by Jonathan Drummey

    Previous row balance to use in current row

    kumar.c

      Hi All,

       

      I have requirement like I have data with different months (monthyear dimension) and different measures. So using these three measure I will get balance every month so closing of the last month balance will be opening balance of current month so I want to use that close balance value in my current month for calculation.

       

      I have attached a excel sheet with some logic in it when you with data. In that Value of Value A is Balance of column F

       

      So need calculation to achieve this. Early solution will be appreciated.

       

      Jonathan Drummey, Andy Kriebel Ben Sullins