5 Replies Latest reply: May 10, 2018 2:14 AM by Aruna dabba RSS

    Using Variable Names loaded in a Table to display results in a chart

    Peter Watt

      I have created an inline table with embedded variable names. I would like to display the result of the variable in a chart/table.

       

      load script:

       

      Reporting:

      Load * INLINE

      [

      Row_Sort, Row, Variable

      1, 'Cy Sales', vCySales

      2, 'Py Sales', vPySales

      ];

       

      I would like to create a tables that shows:

       

      Row                    Variable

      Cy Sales               150,056

      Py Sales               201,004

       

      Instead I am getting the names.

       

      I've tried a few options like:

       

      =$(=Variable)

      =$(Variable)

      ="$(Variable)"

      =[$(=Variable)]

       

      Any ideas?