1 Reply Latest reply on Sep 16, 2017 2:23 AM by Norbert Maijoor

    Tableau Doing Calculation at aggregate rather than at lower granularity?

    Victor Sanabia

      I have this result from tableau:

       

       

      IDHeader 2Total AmountSplitSplit Amount
      12345Gibson100,000.550,000
      12345Fender100,000.550,000
      7892Gibson34,0001.0034,000

       

       

      Everything is correct on this table. I'm using a calculated field to create the Split Amount column. Now when I remove the ID, I get this:

       

       

      Header 2Total AmountSplitSplit Amount
      Fender100,000.550,000
      Gibson134,000.75100,500

       

       

      Everything looks great Except the split amount, I don't want it to do the calculation after the aggregation, I just want it to sum the Split amount before aggregation like this:

       

       

      Header 2Total AmountSplitSplit Amount
      Fender100,000.550,000
      Gibson134,000.7584,000

       

       

      Is this just not possible in Tableau??