4 Replies Latest reply: Jan 13, 2018 3:02 AM by sahil mahajan RSS

    Help with set analysis example

    sahil mahajan

      In one KPI i have Headcount

      and i have a filter as Months



      now what i want is when i select Feb it should give me the headcount for jan in a new KPI


      the expression i am writing is


      count( {$<[As_On link.autoCalendar.Month]={Jan}>} distinct EmployeeNo )


      but i want to achieve this by not mentioning jan i want it to give me headcount for current selection - 1