How to create a proportion according to two dfferent row column value.

[ThomasAmb33]

Hello Everybody,
I would like to add to this table a column wich represent the proportion of count*(id_salarié) by services ( commercial, compta,marketing, etc)

For exemple : for the Row 0, i would like that the new column give me the proportion that représent 9 count ( “count*(id_salarié)” column) in regard to the total amount of count (Row0 and Row1 = 9+17 =16) for this service ( Commercial).

Thank you verry much in advance

[lelloba]

Hello @ThomasAmb33 ,

here’s what you can do:

• use another group by node to repeat the same calculation but without the column “Sexe” (in this way, you’ll fild the subtotal for column “Service” you’re looking for;
• use a joiner node to add the subtotal in the previous step to the first table.

Creating subtotal in table – lelloba

Have a nice day,
Raffaello

[ThomasAmb33]

Thank you verry much Lelloba, It works perfectly fine.