2 Replies Latest reply on Oct 18, 2018 9:28 PM by Andrew Slutzky

    Fixed LOD Oppty Amount Field Not Aggregating Properly

    Andrew Slutzky

      Hello Tableau Community,



      I'm trying to show total oppty amount at the lead source and employee band range matrix level.



      1) Can you tell me why my Oppty Amount LOD field isn't deduplicating amounts at the row and total aggregated levels?


      Field Name: Oppty Amount

      Calculation: {Fixed [Id (Opportunity)]:MIN([Amount])}

      Incorrect Total: $14M

      Correct Total: $6M-$7M


      2) How would you recommend I fix the LOD field?