Basic HTML Version

|  | Table of Contents |  | View Full Version

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

    Step 2  Click on the Data menu from the Menu bar.

                      Step 3  Select the Pivot Table option from the drop-down menu. A submenu will appear.
                      Step 4  Select the Create option from the submenu.

                               The Select Source dialog box will appear.

                      Step 5  Select the source for your Pivot Table. The different options for selecting the source for
                               your Pivot Table are:

                                    Current selection: If you have already selected the data range.
                                   Named range: It allows you to reference cells with a defined name.
                                   Data source registered in LibreOffice: If you want to use an external database. In

                                   our case, we have selected the Current selection radio button.
                      Step 6  Click on the OK button.

                               The different sections for arranging  fields  in the
                               Pivot Table dialog box are:
                                   Page Fields: This section allows you filter data
                                   by  placing  fields to  control  the  pivot  table
                                   display.

                                    Column Fields: This section is used to display
                                   data in columns.
                                   Row Fields: This section is used to display data in rows.

                                   Data Fields: This section is used to calculate the values.
                      Step 7  Select the desired fields and drag-and-drop them into the desired sections:

                                   Item Name to Row Fields.
                                    Price to Data Fields.

                                    Brand to Column Fields.

                     54     Premium Edition-VII

| 51 52 53 54 55 56 57 58 59 60 61 |