1 Reply Latest reply: Sep 28, 2017 1:31 AM by Arvind Patil RSS

    Append variable into dimension

    Ramanan Nadarajan

      Hi Experts,

       

      Have an inquiry on how do we append a value from a front-end variable into a loaded field from data source ?

      Visualization :

       

      Source table(excel file):

       

      NameSales
      MrA100
      MrB101
      MrC

      102

       

      frontend Variable(achieved thru an input box extension):

      VariableValue
      vTstnameMrD

       

       

      Expected Output :

       

      NameSales
      MrA100
      MrB101
      MrC

      102

      MrD-

       

      Or just ignoring the measure, we just need :

       

      Name
      MrA
      MrB
      MrC
      MrD

       

      Hope you guys any an idea about this, cheers

       

      Ram