You can add multiple sorts to a Worksheet and have subtotals for different categories. Follow the steps below to add multiple subtotals to your Worksheet.
- Sort the Worksheet as required.
- On the Worksheet toolbar select Multiple Subtotals
- In the Multiple subtotals window select the options you need subtotals for.
- Click OK.
- Worksheet will now display the subtotals in the order of the sort applied to the Worksheet.