Grid Grouping

[sspParticipant]

Hi,

I’m using the grid grouping widget, where I will  group common rows with different cost values,

I need to sum the cost values of the individual grouped rows and show it with the group header?

Can anyone please help me, how to retrieve the sub-rows cost data and sum up in the group header in the grid grouping widget?

Thanks & Regards,

Sandhya S P

[Peter StoevKeymaster]

Hi ssp,

We already have a demo with Grouping and Aggregates. See here: http://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/groupsrenderer.htm?arctic

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com/

[sspParticipant]

Hi Peter,

I have a concern regarding the above sample demo on Grouping and Aggregates,
i.e. I will be grouping rows based on column A, whereas the sum of cost values should be done of column B.,

Hardware | 25,000
Hardware | 20,000
Hardware | 5,000
Software | 5,000
Software | 3,000
Software | 2,000

Is this scenario possible using groupsrenderer function??

Thanks & Regards,

ssp

[sspParticipant]

Hi Peter,

Hope I am clear regarding my requirement on Grouping and Aggregates,
i.e. I will be grouping rows based on column A, whereas the sum of cost values should be done of column B.,
eg. when Hardware is grouped, I should get the sum in column B as 25,000( 20,000 + 5,000)

Hardware | 25,000
Hardware | 20,000
Hardware | 5,000
——————————————————————————–
Software | 5,000
Software | 3,000
Software | 2,000
——————————————————————————–

Is this scenario possible using groupsrenderer function??

Thanks & Regards,

ssp

[sspParticipant]

Even though I am able to sum up the grouped data using jqwidgets Grouping and Aggregates, I am supposed to display functionality of subtotal which we can see in excelsheet,

I want to do like this
taskA 1 5 3
taskA 4 8 5
sum 5 13 8
taskB 8 1 0
taskB 1 5 8
sum 9 6 8

Is this work around do able?

[sspParticipant]

I am trying to obtain the jqxgrid as in the following example:

http://dev.sencha.com/playpen/gxt/totals/

Please reply whether is it possible using your widgets?

Thanks & Regards,

ssp

[drv232Participant]

Did you find a solution to this problem of yours ssp? I need this functionality as well!

[Peter StoevKeymaster]

Hi drv232,

We do not have such totals representation in jqxGrid.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com/

[Author]

Posts