Group Aggregate with Paging (showing partial aggregate)

[Nicolas]

I have basic radgrid with paging and grouping enabled. When my datasource has a small number of items everything is fine, however when the grid needs to use paging, my groups footer aggregate is evaluated on the rows of the current page only. I would like to build a custom aggregate function based on all the data (in the group) instead of having "per page per group" totals. How can it be done?

Given I achieve what I just described, would it be possible to hide the group footer ONLY when the end of group is not reached? As you can guess, it might be confusing to see multiple "group totals for the whole group"... Let's say I have a page size of 100 and my first group has 150 items, how could I force the group footer to appear only on the 2nd page (page 1 would have no group footer)?

Let me know if you want me to provide some code.

[Pavlina]

Hello Nicolas,

As you noticed the grid generates Group Aggregate values only for the items on the current page. This behavior is due to the current implementation of RadGrid grouping logic and there are no scheduled plans to modify it.

Sorry for any inconvenience caused.

Greetings,
Pavlina
the Telerik team

[Michael Fellmeth]

If possible, please consider Nicolas' request for future releases, and let me add that it would be helpful to be able to display footer totals only at the end of the table as well. 

While there are certainly scenarios where "running" group totals by page are desirable, it's much more common in my experience to display group totals only at the end of groups. Also, footer totals only at the end of the table.

The current functionality of displaying "running" group totals on every page while displaying footer totals directly beneath that are aggregated over the whole dataset creates a confusing presentation.

Ideally, the options would exist to display either (1) running group totals for each page on every page OR (2) group totals that really are group totals only at the end of the group. And options would also exist that allow footer totals aggregated over the whole dataset to display either (1) on every page OR (2) only at the end of the table.

Thanks for considering this request,
Michael 

[Pavlina]

Hi Michael,
 
I want to assure you that I passed your feature request to our developers for future consideration. Please do not hesitate to contact us if other questions or problems arise.

Kind regards,
Pavlina
the Telerik team

[PRITESH]

I am using radGrid with Grouping and paging enabled,

It shows page wise aggregation in footer instead of showing aggregation at the end of each Group ,
I am using newer version of telerik 2014

does this problem still exists in the new version of telerik or it has been solved?

If solved than please provide the way to get rid of it.,.

Thank You

[Shinu]

Hi Pritesh,

You can use  a  GroupFooterTemplate property for specifying a template that will show inside each group's footer rows. You can use them to provide a more customized look for the group totals display. Take a look at this online demo for more help.
Grid - Group Footers

Thanks,
Shinu

[PRITESH]

Hi Shinu,

I wanted to ask that the Group wise Total in RadGrid Grouping displays at the end of the page while it should
show at the end of each Group,

I have attached screen Shots for the reference , Please provide us Solution and also how can i display text in row to show
Groupwise Total where groupwise total row is displayed  and Grand Total where Last row for total displayed


Thanx and Regard

Pritesh

[Shinu]

Hi Pritesh,

The sample demo on Grid - Group Footers  shows how the Grouping works. Each grouping will display its Aggregate value. I guess you want to display the Aggregate for string field, you can set its Aggregate to Count. Then if you want to display different text on grouping and footer, try the Group footer template.

Thanks,
Shinu

[vaibhav]

Hi pritesh,sonu,

I have also the same requirement as pritesh have and even i am also trying this but still didnot get any clue.

if your issue resolve then can you please share me some clue.

 

Thanks,

Vaibhav Kumar

[Sandhya]

Team,

Can you please suggest how we can display group total at the end of each group. With Show footer true it is displaying total on each page. My group data comes in many pages, lets say 1to 3 pages. I don't want footer total in 1 and 2 pages. I only want total at the end of group in this scenario only on  3 page.  Same question is asked in this thread.Please reply ASAP.

[Kamesh]

is this implemented? this post is at 2013 I believe by this time this feature might be implemented, Please suggest