Dynamic average

[Zaga_69]

Hi guys 🙂

I am trying to create a line reference in  a bar chart. This line reference should calculate the average of total purchases depending on the year selected. 

I tried sth like this:

=Avg({<CostElement={'0006000901', '0006014900'}>} sum(amount) )

However it does not work

Any idea,

BR,

Edi

[forticarrion]

Hello,

I created two combo charts whit this example, take a look.

[pradosh_thakur]

I cant open your qvw . Can you try the below , changed a few things in your expression
=Avg({<CostElement={0006000901, 0006014900},Year=$::Year>} amount )

[Zaga_69]

Hi Pradosh

firstly, thank you for your answer and sorry for my late reply.

I will try it and will let you know if it works,

Best regards,

Edi