How to create averge line into multiple line chart

[Anonymous]

Hi all,

I attached my raw data and desired output in Excel File.The line chart is monthly basis. The chart will show  monthly trend lines for each model, and also want to add  the monthly simple average line for all models.

I also uploaded my QV file, it seemed wrong in expression. It is right for average but wrong for model trends.

Can anyone help me please.

[Anonymous]

Hi Sunny,

Thanks for your kind help.

Under your help, I finally solved the problem now.

Really appreciate!

I hope I can be a master of QV in the near future and don't need occupy your time!

Cheers

[sunny_talwar]

I am so happy that you managed to solve this by yourself. I think the effort you have put in to resolve this will go a long way in your learning.

Cheers