10 Replies Latest reply on Sep 1, 2013 3:35 AM by Ville Tyrväinen

    Inexperience with calculated fields

    Lee Hadden

      Good day,

       

      Getting to grips with Tableau and wondered if anyone can help.

       

      The attachment shows the total of each receipt, entitled 'Total' for each consumer id. What i would like to get to is a grand total of these receipt total for each consumer id.

       

      e.g. consumer id 23590 has 2 receipts - £21.23 & £29.74, total should be £50.97.

       

      I have used the analysis tab to get total and have switched the field 'Total' to a measure, but, do not get anything like £50.97.

       

      Your assistance would be most welcome.