Aggr function in pivot table

[LaureDenivelle]

Hi everyone 

I'm using Qlik Sense August 2022.

I have a pivot table with quantity value per month and I want to know the total % aggregated by 2 dimensions. The table is always fully expended.

For example here we have a total of 2619 for January. So for Distribution of "Niveau 1" I need 1509 / 2619 = 57,62%

For now I tried this : 

Sum({<MYTD = {1}, Mois >} Quantity)
/Sum(TOTAL{<MYTD = {1} >}Quantity)

But when I try to aggr, as a result I have 1509 / Qty all months, not just January.

Then I tried this : 

Aggr(Sum({<MYTD = {1}, Mois >} Quantity)
/Sum(TOTAL{<MYTD = {1} >}Quantity),Month)

Result : 

So not even close to what I'm waiting for 😄 

Here a set of Data to reproduce my case. 

Thanks for your help.

Regards

[Or · Accepted solution]

Perhaps:

Sum({<MYTD = {1}, Mois >} Quantity

/

Sum({<MYTD = {1}, Mois >} Total <Month> Quantity)

[LaureDenivelle]

How effective !

thanks a lot, it works.

Regards