How to Hide 2 Same Column Values?

[#1]

Hi All,

How do i hide Values that are the same on Column A and on Column B

Thanks

[alexandros17]

Col A and B are dimensions or expressions?

[#3]

Hi,

They are Dimensions.

Thanks

[rajeshvaswani77]

Hi,

If you put in a Pivot table, they will get grouped as one.

thanks,

Rajesh Vaswani

[#5]

Hi,

The client need it in Straight Table.

Thanks.

[maxgro]

maybe

add a calculated dimension for field f1 and field f2

=if(f1=f2, null(),'')

suppress when null

hide this dimension in presentation tab

[#7]

Hi Massimo,

Thanks alot i used your code and it work Fine the way i want.

Thanks.

[maxgro]

if you get the answer please close the discussion giving correct and/or helpful

[#9]

Hi All,

Massimo Managed to Help me with the Script.

Thanks Guys