how to create an index over 12 months?

[lmonincx]

Hi,

I am trying to create a chart displaying the index growth per month.

for example

Month QTY %to display

Jan 100 0% ( as no earlier data is available)

feb 150 50%

mar 120 -20 % ( as its 20% lower than data in feb)

any suggestions? I would like to display one year of data in such a way ( jan-dec).

See attached qvw with testdata.

any help is appreciated

Linda Monincx

[#2 · Accepted solution]

Hi Linda,

see the attached example for help.

Good luck!

Rainer

[#3]

Hi Linda.

Step one: Sort the months by Numeric value.

Step two: Create another expression, which has the following formula:

Sum (Qty)/Above(Qty)-1

Regards,

Montal.

[lmonincx]

Hi all,

thanks the above function did the job, good learningpoint of the day

Kind regards,

Linda