3 Replies Latest reply: Jan 19, 2018 4:14 AM by Sunny Talwar RSS

    ignoring dimension filters based on a specific month

    Andy Cosgrove

      I want a KPI filter to show the average for the 'mfg_DCIPU' for the selected 'MonthYear'  filter of 20174 (which works out at 2200) while ignoring mfg_cat filters or any others .

       

      I used the following expression: Avg({1 <mfg_DCIPU>} mfg_DCIPU) but it only returns the mfg_DCIPU for the entire data range (2100) while ignoring all other filters

       

      All help appreciated

           

      mfg_catMonthYearYearMonthMonthNbrmfg_DCIPU
      Bally201642016April41000
      IGT201642016April42000
      Konami201642016April43000
      Bally201742017April41100
      IGT201742017April42200
      Konami201742017April43300