3 Replies Latest reply on Dec 19, 2016 5:23 PM by Sid Surana

    Simple Calculation of opening balance and closing balance

    Michael Zervos

      I have data with columns month, seller and Revenue. I have data for one year, so 12 month from january to december

       

      I want to Show the hole data filtered by month as range of values.

      I take seller and Revenue on the grid and month to filter.

      I filter the first 3 month of data.

      I want to have a calculated field which show me the opening Balance of revenue for the first month January and the closing Balance of Revenue for march which is the last month on the window.

       

      Could you help me?