Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am facing a challenge to remove duplicates of employee numbers in a pivot..any help would be appreciated...
What happens when you select 'Suppress When Value Is Null' for your third dimension (I think it says DO, but not completely sure)
It does reduce the data but it takes down the real values as well...I want to eliminate only dupes..
Hi Venkat,
what about your expressions? is it possible to post the sample qvw?
expression is a simple one thou
count(DISTINCT{$<BU_NAME-={NULL}>}EMPLID)
Hi Venkat,
is it possible to post the sample qvw?
Hi Venkat,
Check the expression once, you have added ' - ' after BU_Name.
Hope it helps!!
Post sample application so that it will be easy to give solution
Thank You,
try like : add a calculated dimension
if(len(BU)>0,BU,null()) and then check on the suppress null in dimension