Handling pourcentages in a pivot table

[OmarBenSalem]

Hi all, stalwar1‌ , vinieme12‌

I have the following table :

I'm using this expression:

if(Dimensionality()=1, sum(Taux)/sum(total Taux),

if(Dimensionality()=2,

sum(Taux) /sum(total Taux) ))

What I want is, when dimensionality()=2, to have sum(Taux) / sum(Taux) of the first dimension; the pourcentage of each plaque % its Type Materiel and not % Total

How to achieve this? Thanks

[sunny_talwar]

Check this link out:

Qlik Tips: No nodistinct

[OmarBenSalem]

When I use this expression, It goes back to 0.10%

[sunny_talwar]

When you use this? (My bad, I forgot to remove TOTAL within Sum....

if(Dimensionality()=1, sum(Taux)/sum(total Taux),

if(Dimensionality()=2,

sum(Taux) /Aggr(NODISTINCT Sum(Taux), [Type Materiel]) ))

[OmarBenSalem]

Now we're talking !

[vinieme12]

Preferably avoid AGGR() , because we can achieve it using TOTAL keyword

When should the Aggr() function NOT be used?