How to Add and Remove Subtotals

How to Add and Remove Subtotals

Step 1: Click on any row within the table.

Step 2: From the ribbon, select Home tab| in Tables Area | Subtotal > Add to display the dialog. It is also available from Table Tools tab | Subtotal > Add.



Step 3: Tick the checkboxes next to the rows that are to be subtotal.



Step 4: Click the OK button.

A new subtotal row will be inserted immediately after the last row ticked within the Select dialogue. 
Subtotals must form a continuous group. If you wish to subtotal non-consecutive rows in a table, you must first sort those lines to be in consecutive rows.
Alternatively, if you select the first and last row of a number of rows, CaseWare Working Papers will give you the option to include all rows in between the two selected rows.

Procedure - Delete a Subtotal:
There are multiple ways to delete a subtotal. 
Step 1: Click on any row within the table.

Step 2: From the ribbon, select Home tab| in Table Area | Subtotal > Delete to display the dialog.

Step 3: It is also available from Table Tools tab | Subtotal > Delete and from the Right Click menu.



Step 4: You can also delete a subtotal by right clicking the subtotal cell. 



Step 5: Tick the checkboxes next to the subtotals that are to be deleted. 



Step 6: Click the OK button.
Note: Only those subtotals that have been inserted using Subtotal | Add function can be removed using this option, and not those that are part of the table design.



    • Related Articles

    • How to add or remove a Note Reference in the Financial Statements

      To add/remove a note reference in the Statement of the Financial Position: 1. Using your mouse, select anywhere within the Statement of the Financial Position. 2. From the Statements to the Financial Position tab, select Options and tick Note ...

    • How to prepare an 18 Month period Financial Statement

      Prior year: 12 months ending 30 June XXXX Current year: 18 months ending 31 December XXXX  If there is a change in the entity's reporting date like shown above, there are three primary areas to set:  a. CaseWare file Setup b. Leadsheets / Automatic ...

    • How do I Add Issues to the Financial Statements?

      Issues can be assigned at all levels throughout the financial statements, from a main statement all the way through to a note text section. The flag button represents an issue. To add an issue, complete the following steps: Click the flag button next ...

    • How to Export the Financial Statements into Microsoft Word

      To export Financial Statements to Microsoft Word, follow the procedure below: 1. Open your Financial Statements. 2. From the File tab, select Export > Rich Text Format. 3. In the File Name enter the name of the RTF file. 4. Click Save.   

    • How to add a currency into Agile Audit

      You can add a currency to your engagement or firm template to support additional currencies. Please review the following video for how to add and remove additional currencies: Please contact support@caseware.com.au for the password to view this ...