total of sum distinct in pivot table

[zarmoton]

hello

please can you help me

i have this output in my QV, which is wrong :

but i would like to see that:

here is the input file :

and my qvw example

maybe something to change in the pivot table aor/and in the script who load the data

any idea ?

ragrds

thank you for your help

[Gysbert_Wassenaar · Accepted solution]

replace in your second expression sum((DISTINCT amountconso) with sum(aggr(sum(DISTINCT amountconso),codegroupe))

[zarmoton]

thk you so much, excellent

and any idea how to filter row in this pivot table where last column show value different than 0 ?

regards