How to count last year + next year (like fibonacci)

[#1]

Hey, I have a problem, how to count total year plus next year.

Example:

STATUS    2000     2001     2002

ACTIVE     14          13          5

Status	2000	2001	2002
ACTIVE	14	13	5

What I want is to look this way, coz I'll present it to bar chart, so here's what I want to be displayed.

Here's what I thought to be the formula:

2000 = the count of 2000

2001 = the count of 2000 + 2001

2002 = the count of 2001 + 2002

So the output will be:

Status	2000	2001	2002
ACTIVE	14	13	5

I can't make it to a bar chart... Got problem on this. Need help. Thanks.

Best regards,

Bill

[#2 · Accepted solution]

Hi

Look at the attachment.

I suggest you to do a crosstable then to use a full accumulation.

JJ

[#3]

Thanks JJ, that helps!

Best Regards,

Bill