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

       

       

      Thanks