11 Replies Latest reply on Nov 2, 2018 4:06 PM by Hari Ankem

    How to de-duplicate records before summing up using LOD

    Ritu Chandiramani

      Hello,

       

      I create the initial Tableau dataextract left joining Utilization Table to Membership on certain common dimensions. Now Utilization Table has some additional dimensions (UTLZTN_TYP_CD and  RFRL_TYP_CD) which are not present in Membership table which results in duplicating the membership.

       

      On HI_Patient_Day_Rate worksheet I calculate Membership using Fixed Calculation (MEMBRSHP) which gives me incorrect numbers because of the additional dimensions.

       

      In short I need to make Membership calculation independent of UTILIZATION_TYP_CD and RFL_TYP_CD

       

      Methods already tried - FIXED LOD, Blending