Author Topic: Sub-sub summary for grid that has 2 grouped columns  (Read 3366 times)

TeeJT

  • Pro Ultimate
  • Jr. Member
  • *
  • Posts: 88
    • View Profile
Sub-sub summary for grid that has 2 grouped columns
« on: January 25, 2017, 03:01:35 pm »
I notice that the summary is for the first grouping.
I need the summary for the sub-grouping.

E.g. Employee table that I grouped under Department and then by Grade.
The grid only shows the Department summary but I also need the summary for Grace.

Is there a work-awound this?

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6265
    • View Profile
Re: Sub-sub summary for grid that has 2 grouped columns
« Reply #1 on: January 25, 2017, 03:26:53 pm »
Sub summaries are shown upto any number of levels. Please check this example: https://paramquery.com/pro/demos/group_rows

TeeJT

  • Pro Ultimate
  • Jr. Member
  • *
  • Posts: 88
    • View Profile
Re: Sub-sub summary for grid that has 2 grouped columns
« Reply #2 on: January 26, 2017, 08:14:20 am »
Using the example: https://paramquery.com/pro/demos/group_rows
I added another level of grouping "Customer Name" to the first level "Shipping Country"
In the summary - I only see the grouping summaries for the first level "Shipping Country" but I do not see the sub-sub summary for the second level of grouping "Customer Name" e.g. I want to  see the total for customer "Giovanni Rovelli" under shipping country "Italy".

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6265
    • View Profile
Re: Sub-sub summary for grid that has 2 grouped columns
« Reply #3 on: January 26, 2017, 08:42:03 am »
Giovanni Rovelli under shipping country "Italy" has total of $469.75 as shown in the screenshot.

TeeJT

  • Pro Ultimate
  • Jr. Member
  • *
  • Posts: 88
    • View Profile
Re: Sub-sub summary for grid that has 2 grouped columns
« Reply #4 on: January 26, 2017, 12:58:35 pm »
What I mean is that for "Giovanni Roselli" the view is expanded with the sub-total below.

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6265
    • View Profile
Re: Sub-sub summary for grid that has 2 grouped columns
« Reply #5 on: January 26, 2017, 04:11:47 pm »
Please add this to groupModel:

showSummary: [ true, true ]

TeeJT

  • Pro Ultimate
  • Jr. Member
  • *
  • Posts: 88
    • View Profile
Re: Sub-sub summary for grid that has 2 grouped columns
« Reply #6 on: January 26, 2017, 04:27:10 pm »
Thank you so very much!
That was what I wanted to display.

TeeJT

  • Pro Ultimate
  • Jr. Member
  • *
  • Posts: 88
    • View Profile
Re: Sub-sub summary for grid that has 2 grouped columns
« Reply #7 on: January 26, 2017, 08:02:10 pm »
Is it possible to add a merged row on top of each summary row as a title so as to distinguish the level of the grouping?
A screenshot is shown as attached.

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6265
    • View Profile
Re: Sub-sub summary for grid that has 2 grouped columns
« Reply #8 on: January 27, 2017, 06:41:33 am »
I'm afraid there is no such option to do that.