4 Replies Latest reply on Aug 24, 2018 6:33 PM by Deepak Rai

    Wrong Grand Total on calculated field

    Jonathan Oeijoeng

      I create a calculated field in workbook attached : Net sales = SUM([Price])*SUM([Quantity])

      You can see that on grand total, tableau calculate sum of the price multiply by sum of quantity which give wrong number.

      How can I fix that ? It happen also on subtotal on my other more complex workbook.

       

      Thanks so much

      Jonathan