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

    Previous row balance to use in current row


      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