active employee count

[subbareddykm]

Hi All,

I have one requirement, where i have to count Active on year basis.

But in my case , i have created year and month field in data . i ahve used year filter in dimentions and Expressiomn as Count(Emp)

It is giving me only Active employees in that year only but i want as of respective year.

but if create expression for every year wise and filter data field then it giving me correct and also later want create for Year wise month too.

How can i achieve this?

[muthukumar77]

Hi,

Try this

1. Count({$<Date={"<= $(=Date(Max(Year)))"},Year=, IsActive={'1'}>}Emp)
2. Count({<Date={"<= $(=Date(Max(Year)))"},Year=>}Emp)