ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: TeeJT on January 25, 2017, 03:01:35 pm

Title: Sub-sub summary for grid that has 2 grouped columns
Post by: TeeJT 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?

Title: Re: Sub-sub summary for grid that has 2 grouped columns
Post by: paramvir 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

Title: Re: Sub-sub summary for grid that has 2 grouped columns
Post by: TeeJT 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".

Title: Re: Sub-sub summary for grid that has 2 grouped columns
Post by: paramvir on January 26, 2017, 08:42:03 am

Giovanni Rovelli under shipping country "Italy" has total of $469.75 as shown in the screenshot.

Title: Re: Sub-sub summary for grid that has 2 grouped columns
Post by: TeeJT 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.

Title: Re: Sub-sub summary for grid that has 2 grouped columns
Post by: paramvir on January 26, 2017, 04:11:47 pm

Please add this to groupModel:

showSummary: [ true, true ]

Title: Re: Sub-sub summary for grid that has 2 grouped columns
Post by: TeeJT on January 26, 2017, 04:27:10 pm

Thank you so very much!
That was what I wanted to display.

Title: Re: Sub-sub summary for grid that has 2 grouped columns
Post by: TeeJT 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.

Title: Re: Sub-sub summary for grid that has 2 grouped columns
Post by: paramvir on January 27, 2017, 06:41:33 am

I'm afraid there is no such option to do that.