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,

       

      BACKGROUND:

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

       

      QUESTIONS:

      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?