6 Replies Latest reply on Oct 25, 2016 11:28 PM by Kalyan Chakravarthi Gutta

    Please help me with the dynamic calculation to get latest month data available in datasource

    Kalyan Chakravarthi Gutta

      Hi All, Please refer below for my scenario:

      Below is the my data table:




      And i need Out put like below:




      I wanted to have a calculation to reflect the view with the latest month where data is available


      In future if i get the the data for the different periods for different ID's like below


      ID: 1 and Period 1609 sales as 23

      ID: 2 and Period 1610 sales as 44

      ID: 3 and Period 1611 sales as 72


      Then the output for above should be changed to latest values like below:

      Basically i need a calculation on period to show latest month data against ID.


      Please help me on this as soon as possible.


      Thanks in advance,

      Kalyan Gutta.