# This file show how the groups can be used in filters.
#
# We search for the greatest value of units sold in France. In order to get the
# expected result, we need to filter first the country in France before
# looking for the greatest value.

dataset = "dataset.toml"

[source]
  name = "source"

[sheet]
  columns = [
    ":A",
    ":C",
    ":D",
    ":N",

  ]
  filters = [

    ":C = 'France'",
    ":A = max(:A, [:D], [:F])",

  ]