Only show dimension if value equal to another dimension

Fri, 03 May 2013 07:26:58 GMT

Hi community,

In a pivot table I have two dimension

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!

Re: Only show dimension if value equal to another dimension

alexandros17 — Fri, 03 May 2013 07:29:15 GMT

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