Use dimension value in expression

[guyvermeiren]

Hello,

I would like to create a table where in the dimesion I have year and month and in expressions the turnover for actual year and turnover for year-1.( See example ). I think I have to use the dimension value in my expression. I this correct ? If not, how can this be done succesfully ??

Thanks

Kind regards,

Guy

[#2]

Hi,

Did you tried set analysis?

in your expression, you can inspire from this : =SUM( { $<YEAR={$(=Only(YEAR)-1) } >}turnover)

This should give you the results for the selected year and the previous one.

Hope this helps.

Will

[guyvermeiren]

Hello Will,

This doesn't work. It gives only zero's in th column 'Year-1'.

Any other suggestions ??

Thanks,

Guy

[#4]

Hi,
Why not go for something like this?

using something like:
sum({$<Year = {$(=max(Year))}>} Counter)

sum({$<Year = {$(=max(Year)-1)}>} Counter)

[#5]

Hey,

It's true that JonB 's idea should work better.

[guyvermeiren]

Hello JonB,

The idea is OK but isn't this a standard pivottable. What I want to have is in my column the consecutive months as in in my example I added. EXample: from october 2009 untill september 2010 ( result of selection month/year in listbox).

Thanks anyway.

Kind regards,

Guy

[#7]

Hi Guy,

I made something that should interest you

Hope this helps,

Will