how to ignore duplicated rows

[zied_ahmed1]

Hello..

I have this pivot table and i would like when the row have  code fournisseur = 0 and the Nom Fournisseur = ' - ' disappear because it's the wrong duplicate row

Thanks for help

[zhadrakas]

go to Dimension tab on "Nom F..." and tick "Suppress when Value is null"

[zied_ahmed1]

I need to keep Nom F.. = ' - ' when the code Four <> 0 so i need to do a condition for them together

[zhadrakas]

then try dynamic Dimension for Nom F

=if(code Four <> 0  AND len(trim(Nom F))=0, ' ', Nom F)

and tick "Supress when value is null"

[prieper]

You may choose under dimension to show all value and under Presentation not to display missing or NULL-values

[PrashantSangle]

How many expression do you have??

In all expression try if condition like

if(code fournisseur<>0,YourExpression)

You can modify it in set anlysis.

like

sum({<[code fournisseur]-={0}>}Sales)

Regards,

[zied_ahmed1]

I would like to remove the field with - in Nom fourniss and kept the other.the problem if i i do delete null values i will remove the first row who is not duplicated