Set analysis - field value equal to other field

[nboccassini]

Hi all,

I have an app (attached) with two tables

I need a pivot that sum the value only for loc that have year=year1. The pivot must have type and year as dimensions.

How can I make it ? Using set analysis?

[anat]

=sum({$<value= {"=year = year1"}>}value)

[nboccassini]

Thanks Anat, but it works only if loc has only one year_1.

as you can see, the expression doesn't work for loc=2 (and for year=2019)

any suggest?