« previous next »
Pages: [1]

Author Topic: Sort with grouping  (Read 1947 times)

queensgambit9

  • Pro Ultimate
  • Sr. Member
  • *
  • Posts: 341
    • View Profile
Sort with grouping
« on: August 30, 2018, 06:09:17 pm »
Is it possible to control which level to sort on when using grouped rows?

Logged

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6310
    • View Profile
Re: Sort with grouping
« Reply #1 on: August 31, 2018, 10:27:47 am »
When groups are displayed in a single column as in this demo: https://paramquery.com/pro/demos/group_rows_checkbox

grouped levels are sorted in a hierarchy ie., first Country and then Customer name.

When groups are displayed in different columns as in this demo: https://paramquery.com/pro/demos/group_rows, columns are sorted independently.
Logged

queensgambit9

  • Pro Ultimate
  • Sr. Member
  • *
  • Posts: 341
    • View Profile
Re: Sort with grouping
« Reply #2 on: August 31, 2018, 05:33:24 pm »
Thanks. What about group level? Can a column be sorted on group sum?
Logged

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6310
    • View Profile
Re: Sort with grouping
« Reply #3 on: August 31, 2018, 06:05:19 pm »
Column can't be sorted by group summary/ aggregates.
Logged
Pages: [1]
« previous next »