Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Once you have a report footer, pick a column to be totaled and right click on the report footer row that will display just below the list view

Select 'sum'

 

 

 

from the right click menu that displays in the report footer.


Expand
titleShow me

 


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
titleShow me

 

 


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
titleShow me

 

 


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
titleShow me

 

 


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