Objective: Applying subtotal in LibreOffice Calc
Task: Prepare a worksheet as following
Apply subtotal and find the sum of quantity required for different region.
Solution:
- Open spreadsheet software and enter the data.
- Select the data.
- Click on Data → Subtotal. The Subtotal dialog box appears.
- Select column Project Name in Group By option.
- Now mark the column to Quantities Required to count for this project.
- Select the sum function sum from Use Function option.
Click on OK button
Output:
