Comparing years when year is a dimension

[#1]

Hi All,

I wondered if anyone had an expression based solution to the following problem.

If I have sales data and I want to do a table that has Transaction_Year as the dimension (e.g. 2008, 2009, 2010, 2011) and I want to display the following two expressions:

- Sum(Sales) by year (simple.)

  - Sum(Sales) for the year prior to the year of the current dimension.  So in the 2011 column, I would have the Sum(Sales) for 2010.  This would allow me to develop the formula to do a % change in the same table as the year exists as a dimension.

I want to achieve this without using an independent table and IF statements which is very inefficient for large data sets.

Thanks

GC

[nstefaniuk · Accepted solution]

Hello

You can

- pre-calculate

- use Chart Inter Record functions Above/Below/Before/After but they have restrictions

- use If (sorry)

You can't

- use a dynamic Set Analysis

Chart Inter Record functions

[#3]

Thanks very much I had not known about the Above/Below/Before/After but this was exactly what I was looking for!