Summary table and filter

[Yohan_Boniface]

Hi,

I’d like to create summary table on a subset of a table, “where column XX is not null”, si that doable ?

Eg. :s

I’d like to have a summary of this table, groupe by Département, but only where the column “Dossier” is not null.

Any hint ?

Thank you

Yohan

[alexmojaki]

1. Add a formula column: bool($Dossier)
2. Group by both Department and the boolean formula
3. Filter the summary table by the boolean formula

[Yohan_Boniface]

Thanks @alexmojaki it seems to do the trick!