Trendlines

[p_wikstedt]

Hi there!
Does anyone know if it's possible somehow to add a trendline that is based on several different series?

cheers,

Pekka

 

[p_wikstedt]

I have an idea for doing it afterall, however I would still need help in execution .. The series that I have in the report come from two different crosstab queries, and eventhough I apparently can't get a "combined" trend for all values, I could add an additional column (TOTAL) that sums the values for each year. How do I get it done ??


Vol1;Vol2;Vol3;Vol4;TOTAL
1: 456 456 324 186 sum1
2: 023 789 897 123 sum2
3: 189 159 159 159 sum3


cheers,

Pekka