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

    MONTHLY TREND CALCULATION

    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.

       

      IDCMCM-1CM-2CM-3CM-4CM-5CM-6CM-7CM-8CM-9CM-10CM-11CM-12CM-13CM-14

       

      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