How do I separate the subtotal/total from the report's data?

To separate the subtotal/total

You can create a line to separate the Subtotal/Totals from the rest of the data in the report using the Sort tab.

Note: The Subtotal is for numeric values only.

1. Open an existing report or create one. Navigate to the Sort tab. Sort the order of the report columns with the appropriate field name.

2. Insert a break.

   

3. Specify the Subtotal.

4. Return to the Field Details tab.

5. Select the desired Fieldname. Note: Ensure the Fieldname is numeric for the Subtotal options to appear.

6. Select the Subtotal options.

   

7. Click the OK button.

8. Run the report. The Subtotal/Total is separated accordingly.