jQWidgets Forums

This topic contains 1 reply, has 1 voice, and was last updated by aarffy 10 years, 5 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)

Author

grouping plus a grand total Posts
January 21, 2015 at 5:53 pm grouping plus a grand total #65788

aarffy
Participant

I’m trying to have a grand total at the bottom of a grouping grid.

I tried using the groupsrenderer demo and adding

showaggregates: true

as well as modifying a column to look like this…

text: ‘Quantity’,
datafield: ‘quantity’,
width: 70,
cellsalign: ‘right’,
aggregates: [‘sum’]

… with no luck.

Is there some other approach I can take? Thanks.

January 22, 2015 at 2:01 am grouping plus a grand total #65800
aarffy
Participant
To answer my own, aggregates does work with grouping. You just need to show the status bar to see it.
```
groupable: true,
groupsrenderer: groupsrenderer,  

showstatusbar: true,
statusbarheight: 50,
showaggregates: true,

columns: [{
    ...
},{
    text: 'Quantity', 
    datafield: 'quantity', 
    width: 70, 
    cellsalign: 'right',
    aggregates: ['sum']
},{
    ... 
}],
...
```
Author

Posts

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.