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

    Using variables in Straight table

    Kash Jani



      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.