Having issues to elimniate duplicate

[#1]

I am facing a challenge to remove duplicates of employee numbers in a pivot..any help would be appreciated...

[sunny_talwar]

What happens when you select 'Suppress When Value Is Null' for your third dimension (I think it says DO, but not completely sure)

[#3]

It does reduce the data but it takes down the real values as well...I want to eliminate only dupes..

[settu_periasamy]

Hi Venkat,

what about your expressions? is it possible to post the sample qvw?

[#5]

expression is a simple one thou

[#6]

count(DISTINCT{$<BU_NAME-={NULL}>}EMPLID)

[settu_periasamy]

Hi Venkat,

is it possible to post the sample qvw?

[Anonymous]

Hi Venkat,

Check the expression once, you have added ' - ' after BU_Name.

Hope it helps!!

[Anonymous]

Post sample application so that it will be easy to give solution

Thank You,

[avinashelite]

try like : add a calculated dimension

if(len(BU)>0,BU,null())  and then check on the suppress null in dimension