Point in time Reporting - New / Lost / Total Customer

[#1]

hi i have built an application to assist me with the follow up.

however i am still struggling with these three key figures.

i would like the key figures to represent the respective years in a table.

For example.

Year   New Lost Total

2012   10    0     45

2013   20    5      60

i have attached my document with the conditions and my calculations, but cannot seem to get it right.

any help is greatly appreciated.

Best

Brad

[Gysbert_Wassenaar]

I can't make heads or tails of the data in your document. You're requirement sounds a lot like an earlier question for which I created an example (see attachment).

[#3]

HI.

thank you for your reply.

your example is much the basis of what i am looking for.however, if you were to take away the selection property on the month the logic is lost. Any way to have the logic remaining without selecting the month in your example?

i.e

month  lost new active reactivated

1          0    0      10      0

2          2    0      10      0

3          3    2      12      0

4          4    1      13      0