0 Replies Latest reply: Oct 24, 2017 7:05 AM by Handriko Naftali RSS

    How to make Current Year and Previous Year in one Member Dimension Chart

    Handriko Naftali

      Hi Experts,

       

      I would like to ask how to make current year and previous year sales comparison in one member dimension.

      The bars should have 2 measures which are current year and previous year.

       

      Below is what i am expecting to have.

      Right here, i use firstsortedvalue in formula.

      You will see there is only 1 member dimension (2016) that has detail of current year and previous year. This is what i want.

      62CF5D04.PNG

       

       

      Below is what i currently have.

      Right here, instead of using firstsortedvalue formula, i use only simple sum and set analysis because unfortunately there is particular reason i cannot use firstsortedvalue formula.

      You will see there are 2 separate member dimensions (2016 and 2017). This is NOT what i want.

      B8FB5135.PNG

       

      I would be really grateful if would kindly give feedback upon this question.

       

      Thanks Fellas.

       

      Regards,

       

      Handriko Naftali