Aggregates on the group

[FranciscoParticipant]

Another question about aggregates , can bind it by group, for example , I create a jqxTable to show by customer group total order or recipe?

[ivailoParticipant]

Hi Francisco,

You can calculate your total and display it in groupsRenderer.
There is similar example about jqxGrid aggregates total, so it can be helpful for you.

Best Regards,
Ivailo Ivanov

jQWidgets Team
http://www.jqwidgets.com

[FranciscoParticipant]

OK, I get it, but imegine the following columns, for example, Customer, City, and Total, right?
I would like to group by client, which is easy, use this:
                                    groups: [‘customer’],
                                     groupsRenderer: function (value, RowData, level) {
                                         return “Client: <b>” + value + “</ b>”;
                                     },
Now comes the problem, as I would put the total for each client side in his name? Understood?

I’m not grouping by all, just including this information in function groupsRender!

[ivailoParticipant]

Hi Francisco,

You have first to calculate some result and then to display it in groupsRenrer.
Please look at this demo.

Best Regards,
Ivailo Ivanov

jQWidgets Team
http://www.jqwidgets.com

[FranciscoParticipant]

Thank Ivailo!!!

It was exactly what I was trying to do, thanks for your insight!

[Author]

Posts