Summary table and filter


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 :slight_smile:


  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

Thanks @alexmojaki it seems to do the trick! :slight_smile: