4 Replies Latest reply on Nov 1, 2016 8:34 AM by David Lam

    SUM on GROUP

    David Lam

      Good Afternoon,

       

      Given the following data set:

       

      LocationChargeIDTransIDAmount
      MainA488T95656$80.00
      MainA488T24586$80.00
      Main65BvT84457$76.00
      East5G51T96367$90.00
      East5G51T47852$90.00
      East5G51T12214$90.00

       

      My goal is to get it down to:

       

      Location
      Amount
      Main$156.00
      East$90.00

       

      I can do this all day in SQL but am trying to do it in the Tableau UI. I've tried the suggestions below but it never gives the right sum (way too high).

       

      How to calculate sum of distinct values

      Sum Distinct?

      how to do a simple SUM DISTINCT in tableau? 

       

      I can't post my twbx because it contains confidential data but can try to dummy it up if need be.