3 Replies Latest reply: Mar 2, 2017 5:10 AM by Gourav Sikka RSS


    Gourav Sikka

      Dear Team,


      I stuck a requirement.I have a data from Last Two years. And i want to make monthly trend report in straight table One to one expression. For this i make a result format below.




      Each Month's Column Data Should be On Max Date..Suppose in one Month 4 Dates exists Like In Feb Month 22 Feb,23 Feb,24 Feb.

      In CM-1's Column data only 24 feb means each month's maximum date..same like previous month..

      For this i am sharing data ..In Each Column  data exists only maximum date. And Second Sheet Result As required