6 Replies Latest reply: Aug 11, 2016 4:42 AM by Massimo Grossi RSS

    Using variables in Straight table

    Kash Jani

      Hello

       

      I have a variable to do a sum of a field in my data model. The result is then split by another field in the column

       

      For e.g. Sum of total customers. This is then split by countries.

       

      UK - 500

      US - 300

      Total - 800

       


      If I use a straight table with Countries as dimension and =SUM(totalcustomers) as expression, this works all OK.

       

      If I then use a variable to store the sum of total customers and use this variable as expression, the straight table doesn't seem to split by countries. It shows the total customers for all countries.

       

      UK - 800

       

      US - 800

       

      Please see attached.

       

      Thanks