Crosstab question

[Steve]

Hi All !

The requirement is to display measures in a crosstab for multiple years which will be selected from a Value Prompt. That's quite straightforward but then there will be a column to show the difference in amounts between Year 1 and Year 2. If the user selects 5 years from the prompt then there will be one column to show difference between Year 5 - Year 4, another column to show difference between year 4 - Year 3 and so on. Moreover, there will be one crosstab for every year (which I can achieve by sectioning the crosstab) but how would I display the difference? Is it possible?

I am thinking to restrict the user to select one year and then use calculated columns to calculate the difference between the Year selected and the one before that and so on and then display them all in one list or crosstab but wanted to check if what I have written above is possible.

Thanks in advance !