Current Month Value

[#1]

Hi ,

I want to display the count of New managers in the Current month but a  not a manager in the previous month.

Addition of Manager in Current Month.

example: consider current month is Feb

Month  Manager Id

Jan       A         1

Jan       B          2

Jan      C         3

Month Manager Id

Feb     A         1

Feb     B         2

Feb    D         5

Feb     E        6

now count of new Managers in Current Month (Feb) is 2

Any Help would be appreciated.

Thanks,

Kavya

[sunny_talwar]

May be this:

=Count(DISTINCT {<MonthNum = {'$(=Max(MonthNum))'}, ID = e({<MonthNum = {'$(=Max(MonthNum) - 1)'}>})>}ID)

[#3]

Hi Sunny

i want output  in chart like this.

Month	New Manager                    count
Jan	0
Feb	2

Thanks,

Kavya

[sunny_talwar]

Not sure how this would look if you have more than 2 months. But for two months the same expression seems to work:

[#5]

I want to display for more than two months

[sasikanth]

hi,

Try this exp

=Count(DISTINCT {<MonthNum = {'$(=Max(MonthNum))'}, ID = e({<MonthNum = {'<$(=Max(MonthNum))'}>})>}  ID)