5 Replies Latest reply: Oct 27, 2014 1:59 PM by Jose Tos RSS

    Ignore Some Dimensions in an Expression

      I have created the expression "MM's", which is a membership field in my pivot table. In the image below, the top field contains the correct membership numbers. However, when I add claim fields in front of my population field ("Benchmarks"), it looks to only be counting members WITH a claim in that field.

       

      Here is the MM's formula I am using for the first chart, which works:

      sum({1 <BENCHMARKS= P(BENCHMARKS), INCURRED_YEAR= P(INCURRED_YEAR), INCURRED_YEAR_AND_MONTH= P(INCURRED_YEAR_AND_MONTH)>} MM_UNITS)

       

      Here is the MM's formula I am using for the second chart, which does NOT seem to work:

      sum (Total <INCURRED_YEAR_AND_MONTH, INCURRED_YEAR, BENCHMARKS> MM_UNITS)

      • My goal with this formula is to sum MM_Units IGNORING all dimensions except: INCURRED_YEAR_AND_MONTH, INCURRED_YEAR, and BENCHMARKS.
      • But it looks like it is still considering my claim fields: HCG_HIP_HOP and HCG_MR_LINE_ROLLUP_DESCR

       

      Thank you in advance.