SubTotal in pivot table

[lessassy]

Hello everyone all,



I have the following table:




It is a pivot table.

In the sub-total section, I would like to add the percentages instead of adding the percentages, while keeping the direction column.

Because I know that I can achieve the average by removing this column but I would prefer to find another solution.

Thank you in advance.

[Taoufiq_Zarra]

as i said you can change your expression by

=avg(aggr(TONEXPRESSION,Direction,Département))

[lessassy]

Thank you,

It works if i have only keep one dimension "Departement"

But if i add the other dimension "Direction" I don't have the nulber i want

[Brett_Bleess]

I suspect the following Design Blog post may get you what you need or on the right track:

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

Regards,
Brett