Modify expression

[Anonymous]

Hi,

Please help me to modify expression avg({1} MyField)

I want to show avg of all, but manage by Filter MYear.

In my case if I select any month in MYear, it shows trend for all month.

Thanks,

[Anonymous]

Filter works with this expression

avg(TOTAL<MYear>{$< Client*=, Industries*=>}[MyField])

but the result is wrong.

I need to investigate it.

[whiteline · Accepted solution]

=avg({1<MYear=P(MYear)>}MyField)

[#4]

you didn't tell you've got only two dimensions to clear:)

this should work

avg({$<Client=, Industries=>} MyField)

also whiteline got fine idea

[Anonymous]

Thank you for your help.

You really helped me.