intersection previous week and this week

[#1]

hello,

i have some trouble to find the right solution.

let`s say i have following table:

id	week	flag
1	1	1
1	3	1
1	4	1
2	1	1
2	2	1
2	3	1

what i´m trying to achieve is following result:

Dimension: week

expressions:

- count all ids which have an entry in previous week and this week --> active previous week + active this week

- count all ids which have no entry in previous week but entry in this week --> active previous week + not active this week

- count all ids which have an entry in previous week but no entry in this week --> not active previous week + active this week

Week	active previous week + active this week	active previous week + not active this week	not active previous week + active this week
1	-	-	-
2	1	1
3	1		1
4	1	1

I struggeling around for a while an couldn`t find any solution. I tried it with aggr function and above function but have no satisfying results.

I hope somebody can help me! it´s really important

Thanks

Stevve