5 Replies Latest reply: Feb 6, 2017 8:50 AM by Sunny Talwar RSS

    Customized Value List

    payal pg

      HI community,

       

      My requirement is i need to show all the MTD,QTD,YTD for both value1,value3.But for value2

      only MTD should display. And the lable name should be displayed as 'Compression' instead of MTD. Please find the following attachment and kindly help me with this

       

      Thanks in advance

        • Re: Customized Value List
          Sunny Talwar

          Try this approach by adding this to your script

           

          Dim:

          LOAD * Inline [

          Dim1, Dim2

          1, 1

          1, 2

          1, 3

          2, 1

          3, 1

          3, 2

          3, 3

          ];

           

          and then use three dimensions

           

          1) Date

          2) =Pick(Dim1, 'value1', 'value2', 'value3')

          3) =Pick(Dim2, 'MTD', 'QTD', 'YTD')

           

          Expression:

          Pick(Dim2,

            If(Dim1 = 1, sum({$<Date = {"$(=rMTD)"}>} Sales),

            If(Dim1 = 2, sum({$<Date = {"$(=rMTD)"}>} Budget),

            If(Dim1 = 3, sum({$<Date = {"$(=rMTD)"}>} Forecast)))),

           

            If(Dim1 = 1, sum({$<Date = {"$(=rQTD)"}>} Sales),

            If(Dim1 = 2, sum({$<Date = {"$(=rQTD)"}>} Budget),

            If(Dim1 = 3, sum({$<Date = {"$(=rQTD)"}>} Forecast)))),

           

            If(Dim1 = 1, sum({$<Date = {"$(=rYTD)"}>} Sales),

            If(Dim1 = 2, sum({$<Date = {"$(=rYTD)"}>} Budget),

            If(Dim1 = 3, sum({$<Date = {"$(=rYTD)"}>} Forecast))))

          )

           

          Capture.PNG