2 Replies Latest reply: Nov 12, 2015 5:10 AM by bruno bertels RSS

    pick

    Fabio Mazzarelli

      Hi Community,

       

      i create a table

      Immagine.png

       

      how to replace the column names with the values shown in the legend


      Fabio M

        • Re: pick
          Andy Weir

          Labels on pivots cannot be dynamically set yet.  You would need to replace the filed names 1,2,3,4 with (Presa, Tratta etc...) in your data load.

          • Re: pick
            bruno bertels

            Hi Fabio

             

            It seems you have a dimension called "TipoCosti" with the fallowing values 1, 2, 3 , 4 that's representing Presa, Tratta etc

             

            You can add this in the script like that :

             

            Load

             

            TipoCosti,

             

            If(Tipocosti='1','Presa',

            if (TipoCosti='2','Tratta',

            if (TipoCosti='3','Distribuzione',

            if (TipoCosti='4','Passiaggio a Magazzino',)))) as "TipoCostiLabel",

             

            So it will add you a new dimension called TipoCostiLabel in your data

             

            Replace TipoCosti with this new dimension TipoCostiLabel so you will see the text value rather than 1 or 2 etc

             

            Hope it' helps,

             

            Bruno