Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 54 - 2505_CoreGPT(Podar)_Flipbook_C7
P. 54

    Tech Funda

                             You can also set input help messages to guide the user on what type of data to enter
                             into a cell.

                            CALCULATING SUBTOTAL IN DATABASE

                      LibreOffice Calc offers the Subtotals tool to create subtotals for data arranged in labelled columns.

                      It also groups subtotals by category and sorts them automatically, thereby eliminating the need
                      to apply filter categories manually.

                      The Subtotal command is used to automatically create groups and apply inbuilt functions like
                      SUM, COUNT, AVERAGE, etc., to summarise data. One can use any type of summary function for
                      each column as per the requirement of data analysis. It can group subtotals by using category
                      and sorts them in ascending or descending order so that one need not use filters.

                      For example, the Subtotals command can be used to calculate the number of Jerseys of different
                      sizes required for players.

                      To insert Subtotal values into a sheet, follow these steps:
                      Step 1  Select the range of cells with values for which Subtotal function needs to be implemented.

                               Ensure that the columns must have labels.
                               The subtotal function has a graphical interface and is accessible from Data menu.

                               Using the Subtotals, you can select arrays and then choose a statistical function to apply
                               to them. For efficiency, you can choose up to three group of arrays to which a function
                               can be applied.

                      Step 2  Click on the Data menu. Select Subtotals option. Subtotals dialog box appears on the
                               screen.

                      Step 3  In 1st Group tab, from the Group by drop down box, select the column for which
                               subtotal is required. If the content of the selected column changes, the subtotals will

                               automatically be updated.

                      Step 4  In the Calculate subtotals for box, select the columns for which subtotal needs to be
                               calculated.
                      Step 5  In Use function box, select the desired function to calculate the subtotals. (Here, we

                               have used Sum function.)

                     52     Premium Edition-VII

| 49 50 51 52 53 54 55 56 57 58 59 |