5 Replies Latest reply on Jan 18, 2017 6:38 AM by Fabian Gantner

    Correct %-deviation calculation in Grand Total

    Fabian Gantner

      Hi, I have a question concerning the correct calculation of totals in calculated fields. For a better understanding I attached an excel with the crosstab of my Tableau Workbook.

       

      The problem I have you can see in column I, J and K. The Grand Total calculations are showing the wrong result (see line 3). Correct calculation I added to line 1. In column I and J I can switch to "Total using Sum". But I need the two reults from I and J to calculate the correct result for K. Any ideas how to solve this issue within Tableau?

       

      Thanks!