6 Replies Latest reply on Apr 18, 2018 7:52 AM by Joan Zhou

    Can not get expected total. Aggregation before calculation when use Total

    Joan Zhou

      Tableau calculate total in a higher level. when I try to get total for a calculation field, I can not get expected answer. below is the case:

      I have Units from database A, Unit cost from database B, I create a calculation file to get product total cost by using [Units] * [units cost]

       

      when I add total, Tableau aggregate all unit together to 139, and add all unit cost together to $1332, and then use 139*$1,332=$185,148.

      but this total is not what I want. I actually want to sum ( [total cost] ), which is $18,017

       

      Does any one know how to make the total correct?