11 Replies Latest reply on Dec 8, 2015 10:05 PM by Nikunj Bhardava

    How to display the current month data from a historic data

    Vishant Nayak

      Hi Team,

       

      I am trying to get the current month data without a filter from a database which is updated on a monthly basis (values and expiry changes for the same data sets).

      Capture1.JPG

      I would require only the current month data for each " Code" ( the one mentioned above). But I get the below data with the historic information. Without using the filters, can I have the current month data for the "Code".

      below attached sample file

      Capture.JPG

       

      Please help!!

       

      Thanks,

      Vishant