How to create an Linechart with index?

[michael84]

Hello

I want to create a Line Chart as an Index. That means it should start in the year 2007 which is 100% and each following year refers to the first (actually selectet year) and shows the value in % of the basic year.

Here is an example how it should look like. Does somone know how to create such a graph that is also dynamic?

Thanks for your help

Michael

[#2 · Accepted solution]

Hi Michael,

You should try this expression :

sum(pflegetage) / sum({$<Year={'$(=min(Year))'}>}Total pflegetage)

I think it will work !

Good Luck !

[michael84]

Hi Paul,

Thanks a lot for your help it wort out perfect!!