Bypassing dimension

[Anonymous]

Hi,

I want to create a chart showing gross sales development, but I have a challange.
Currently I have data for 2011 and 2012. The user always have to select one year.
Dimension : Year

1) Show sales in year
Expression : sum({<Year=>} [Invoice Amount Group])

This work fine and shows a result for both 2011 and 2012

2) Show increase in %
Expression : sum({<Year=>} [Invoice Amount Group]) / sum({<Year={2011}>} [Invoice Amount Group])

This only shows a result for 2011. Where did 2012 go???

Any ideas to get 2) working

Kind regards
Nils

[MayilVahanan]

Hi

Try like this

Expression :

=sum({<Year={$(max(Year))}>} [Invoice Amount Group]) / sum({1} [Invoice Amount Group])

Hope that helps

[Anonymous]

Sorry... this dosen't help.

and next year I'll have 3 years of data ... 2013 must by compared against 2012, 2012 against 2011.... and so on

Any ideas?

Regards

Nils

[MayilVahanan]

HI

Check the attached file. Hope it helps

[Anonymous]

Hi,

Thank you for your help, Mayil.

Your solution works fine with a fixed number of years.... but what if I want to use it with month as dimension. Then I'll have to repeat the expressions

I need it to be dynamic

Best regards

Nils

[MayilVahanan]

Hi

Can you post a sample file?

[Anonymous · Accepted solution]

Hi,

I found a solution : The Above() function

Thanks for your input

Br

Nils