Hi !
From this :
I would like a result like this :
I'm only able to make that :
Is there a way ? :)
Thanks in advance
The four "Statut" columns can be set up through the "Count specific value in column" under "Aggregations". The "Total" column with "Basic aggregation of column" that counts the rows of the "FluxNom" column.
To get the "Total" row, set up a subset for each value of "FluxNom" and one all encompassing subset "Total" (no filters).
You can also achieve this wihtout having to set up a subset for each FluxNom value by manually editing the query. All existing values are aggregated in a single statement with the GROUP BY clause and the "Total" row is added onto the table with UNION ALL (which the subsets use).
This does have the disadvanted however that value of FluxNom that do not have a row (yet) will not appear in the result table, whereas using the subsets allows for empty rows.
15 People are following this question.
