Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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
so how can i modified set analysis to avoid this problem?
This depends on what outcome you want?
I still unclear about your requirements !
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