Create Variance by Year with set analysis

[#1]

I have a set of values for 5 years.

Such as:

2000 - 10,000

2001 - 12,000

2002 - 13,450

2003 - 9,000

2004 - 8,000

I want to show the difference in the values by year. I can do the following with set analysis:

2003 2004 Difference

9,000 8,000 1,000

What I want is to show the difference by year in a table:

2001 2002 2003 2004

2,000 1,450 -4,450 -1,000

Anyway to do this

[#2 · Accepted solution]

I think you need to use the function Above, see in help.

[johnw]

I'd use an AsOf table. See attached.

[#4]

Works. I appreciate it. Johnny

[#5]

Slick. Answered my next questions. Thanks... Johnny

[#6]

Thank you John your answer were useful for me too...thank you