6 Replies Latest reply on Nov 6, 2018 6:47 AM by Deepak Rai

    Fix LOD Calculation on a Filter Value

    Ritu Chandiramani

      Hello,

       

      I have an LOD calculation in my workbook  which calculates Membership (See below formula)

       

      { FIXED  [RGN_CD], [YEAR], [MONTH], [MJR_AREA_NM], [AGE_BAND_CTGRY_DS_TX], [LINE_OF_BUSINESS], [LINE_OF_BUSINESS_SGRP], [UTLZTN_TYP_CD] : MIN([MEMBSHP_CY_MTH_CT])}

       

      Now UTLZTN_TYP_CD is a filter which has three values KFH, Claims and Referrals.

       

      Currently this calculation changes based on value that I select in UTLZTN_TYP_CD filter.  I need to make the calculation fixed on value  UTLZTN_TYP_CD = "KFH". I tried modifying the formula as below:

       

      { FIXED  [RGN_CD], [YEAR], [MONTH], [MJR_AREA_NM], [AGE_BAND_CTGRY_DS_TX], [LINE_OF_BUSINESS], [LINE_OF_BUSINESS_SGRP], [UTLZTN_TYP_CD]  = "KFH" : MIN([MEMBSHP_CY_MTH_CT])}

       

      But this doesn't work.

       

      Any insights to achieve this functionality will be very helpful.

       

      Ken Flerlage, I have attached the packaged workbook for your reference