Duplicated row in pivot table

[zied_ahmed1]

Hello,

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

How to do it...

Thank you

[zied_ahmed1]

omarbensalem‌

[OmarBenSalem]

add a new measure as follow:

count(total <NumFournisseur> NomFournisseur)

u'll have normally, lines where u have only 1 NomFournisseur and others (the one u want to remove) wwith more than one NomFournisseur.

try, and tell me if it's the case?

[zied_ahmed1]

[OmarBenSalem]

can u please show me the repo line where there was a duplication?

[stabben23]

Hi,

it looks like you have concatenate two or more datasets.

In Your table, ill think you use one or more Field as dimension which is not concatenated, i.e common keys.

[OmarBenSalem]

Zied, try to adapt this logic to ur need:

Let's assume I have this :

Related to ur case; we should elminate the duplication in the num=1 since it has 2 names:

to do so; instead of this num dimension, create it as a MEASURE like this:

aggr(only({<num={"=isnull(aggr(count(nom),num))<>-1"}>} num),num)

result:

We'll then need only to uncheck show null values for the new NewNum measure and the duplication is elimnated;