Only show dimension if value equal to another dimension

[#1]

Hi community,

In a pivot table I have two dimension

Dimension1	Dimension2
103063	1961
103063	10361
103063	103063
103063	103063

I only want to make sure that the values from Dimension 2 show when thay are equal to Dimension 1. And not see the other records at all.

I have searched the forum but can't find a solution.

I have tried this calculated dimension since it seems logical but it aint working:

=only({$<Dimension2 = {'Dimension1'}>} Dimension2)

Thanks for the help!

[alexandros17 · Accepted solution]

Try this:

if(dimension1 = dimension2, dimension1, null())

in the dimension and check box "exclude null value"

Obviously there will be only 1 dimension

Hope it helps