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..
what about your expressions? is it possible to post the sample qvw?
expression is a simple one thou
try like : add a calculated dimension
if(len(BU)>0,BU,null()) and then check on the suppress null in dimension
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
is it possible to post the sample qvw?
First of all at first it seems there is one to many relationship in data model due to null values. Please provide a complete details of the table you are using and the data you are reloading .
Sometimes, if you have some space or anything in the source data, it will not be treated as NULL.. so use function such as len(trim(field_name))=0...
Retrieving data ...