11. How to Add Sums, Counts, and Other Expressions

  1. Now that a group has been added, it is possible to add sum fields by simply right clicking on the field that needs to be summarized and then choose Expression
  1. In the expression Category window, choose the Common Functions and expand and click on Aggregte and then choose the type of summary from the Item list
  1. Next, click on Fields (Dataset1) and then select field to aggregate such as ClientId to create a count of client IDs and manually enter the end parenthesis and click OK
  1. To insert a grand total, right click in group footer and select Add Total and then select After
  1. Click Preview