1 Reply Latest reply on Oct 28, 2016 3:28 PM by diego.medrano

    Prev 4 based on current selection

    Sonali chavan

      Hi All,

       

      1. Consider the hierarchy Yr->HalfYr->Qtr->Mnth which are string fields. After selecting a year it should display previous 4 years.’

      2. When going for HY level it should display previous 4 Half year from the selected Year and HY.

      3. Same is the case for Qtr and month

       

      For e.g.   IF selecting Year-2015-2016 and Hy-H2 then it should give me previous 4 Hy.

      If I am selecting Jan 2015-2016 it should give me Jan16, dec-15, nov-15,Oct-15

       

        

      Yr

      HY

      QTr

      Month

      2014-2015

      H1

      Q1

      Jan

      H1

      Q1

      Feb

      H1

      Q1

      Mar

      H1

      Q2

      Apr

      H1

      Q2

      May

      H1

      Q2

      June

      H2

      Q3

      July

      H2

      Q3

      Aug

      H2

      Q3

      Sept

      H2

      Q4

      Oct

      H2

      Q4

      Nov

      H2

      Q4

      Dec

      2015-2016

      H1

      Q1

      Jan

      H1

      Q1

      Feb

      H1

      Q1

      Mar

      H1

      Q2

      Apr

      H1

      Q2

      May

      H1

      Q2

      June

      H2

      Q3

      July

      H2

      Q3

      Aug

      H2

      Q3

      Sept

      H2

      Q4

      Oct

      H2

      Q4

      Nov

      H2

      Q4

      Dec

       

       

      Regards,

      Sonali.