5 Replies Latest reply on Feb 14, 2020 7:17 AM by Rohit Yeruva

    Help with aggregation

    Santo Fortebuono

      I have a normalized dataset in Tableau that looks like this:

       

      I want to create a Tableau report that will end up looking similar to the following:

       

       

      The issue is that Tableau always sums the baseline first and then subtracts the sensitivity amount.

       

       

      For example,  The MortDec, Delta from Baseline should equal 2,171.41, which is 10,907.44 – 8,736.03.  However, in Tableau the totals that’s calculated equals 11,586.44, which is incorrect (fyi, 13,757.85 + 8,736.03 – 10,907.44)

       

      Fyi,