How can I show only the values that are intersected in columns from 2 tables?

[lrdrogerio]

I'm using a Pivot table and I have 2 columns that should have the same names.

I'm creating a dashboard to show the products sales summaries, and I want to only show the values that are present in both columns.

I'm sure I"ll have to use set analysis but I couldn't make it yet.

[andrey_krylov]

Hi Rogerio. Try this set analysis

Sum({< [Field1] = {$(=Chr(34)&Concat(DISTINCT [Field2], '","')&Chr(34))} >} Amount)

[Field1] and [Field2] - the columns with the same values