Expression issue

[#1]

Hi

I have a plot-chart with 2 dimensions :   MONTH  ,  YEAR

and one expression  :      Sum(   Value) 

My objective is to change the expression to transform it in an index as

Sum( Value) /  Sum(  the value of first month) 

How to write the denominator taking account the first month for each years in my expressions

Thanks for your help

JJ

[CELAMBARASAN · Accepted solution]

Try something like

Sum(Value)/Sum(TOTAL <YEAR> {<Month={'Jan'}>} Value)

[#3]

Thanks Cel

What about if my first month is not Jan ?

JJ

[CELAMBARASAN]

You mean it differs for every year?

[#5]

Yep! Thanks for tour effort

[swuehl]

Have you tried already with the chart inter record functions, namely top()?