...
Select 'sum' from the right click menu that displays in the report footer.
Expand | ||
---|---|---|
| ||
Adding a subtotal to a list view
First right click on some field to be used for totals and select group by this field
Then right click and select show group header. By default the group by will count the field you are grouping by.
You can group by two things like assigned to and day on deliveries or sales person and customer to get two levels of subtotal. At each level you can count or sum the results. This lets you get just about all the features of a report without having to make a report at all. You can then use the view variant to save your list view, just like it was a report and use it again in future.
Conditional formatting can be used to complement subtotals by colour coding exceptions such as transactions with low gp, overdue items etc.
For this example, I will group by customer on my open item list.
...
Then in the group header, right click on the field you are grouping by, in this case card,
Expand | ||
---|---|---|
| ||
|
...
Then on the group footer, right click and select sum on the column you are trying to subtotal
...
You may need to click on the full expand option on the field you are grouping by in order to see the details being totalled
Expand | ||
---|---|---|
| ||
|
Adding totals to group subheaders
By default, your group subheaders will count the number of records in the group.
To add subtotals to the header, right click on the field being grouped, select the group summary editor, then check the tickbox to sum the field you want totalled
Expand | ||
---|---|---|
| ||
|
Now, in our example we have group headers with totals, group footers with totals and a report total at the end
...
https://documentation.devexpress.com/#InterfaceElementsWin/CustomDocument4574