Set analysis

[#1]

Hi All, nedd help, i have a table :

AbonementID	AbonementEndDate
1	2013.03.03
2	2013.03.04
3	2013.03.06
4	2013.02.04
5	2013.02.05
6	2013.04.06
7	2013.02.07
8	2013.03.08
9	2013.03.09
10	2013.04.10
11	2013.04.11
12	2013.06.12

i need 2 set analysis, one: i need count all active abonements at the start of month, for examp: at 1 of march i have 9 active abonements,

second set analysis: i need count all active adonements at the month  end(march 31), expecting result =3

please help

[#2]

thanks again, and one more question , ok, if i select on master calendar year and month its show me correct values, but if is no selected in the calendar its show me a wrong values..why? i need . when i activating sheet, it show me all tendency by year and month of abonements..now my set analysis is:

COUNT({<Abonement.End = {">=$(=MonthStart(Max(Date)))"}>}distinct SabID)

and

COUNT({<Abonement.End = {">=$(=MonthEnd(Max(Date)))"}>}distinct SabID)

[MK_QSL]

If you will not select anything, you will get result

for 1st Expression This Month TO DATE data...

for 2nd Expression ,,, will give you null or o

[#4]

so how can i modified set analysis to avoid this problem?

[MK_QSL]

This depends on what outcome you want?

I still unclear about your requirements !

[#6]

now its calculate only if i select year and month in master calendar, and calculate id only in one month, i want without any selection in master calendar calculale id in each available month