Tuto WINDEV 25

Part 4: Full application with data 235 ▶ To create a new tab pane in "WIN_Menu": 1. Display "WIN_Menu" in the window editor (if necessary). 2. Double-click the Tab control: the control description window appears. 3.  In the "General" tab, select the "Chart" tab pane and click the "New" button. A new tab pane appears. 4. Select the new tab pane (named "Pane 5"). 5.  In the right section of the screen, type the caption of tab pane: "Pivot Table". 6.  In the right section of the screen, select an image in the image catalog: • Click the button on the right of "Image" control. Select "Catalog" from the popup menu that is displayed. • The window of image catalog is displayed. • In the search control, enter "Array". • Start the search by clicking the button with the magnifier. • Select for example, and validate the different screens that appear. 7. Validate the description window of Tab control. 8.  The new tab pane appears in the window. Creating the Pivot Table control ▶ To create a Pivot table control: 1.  In "WIN_Menu", select the "Pivot Table" tab pane if necessary. 2. On the "Creation" pane, in the "Data" group, expand "Table and List Box" and select "Pivot Table (PVT)". The control appears under the mouse cursor. 3. Click the "Pivot Table" tab pane. The wizard for creating a Pivot Table control starts. 4. Go to the next step. 5. Various information must be displayed in the cells : • the total sales amount. • the quantity sold. We are going to select the source data file in the wizard: OrderLine. For the first information, select: • Display: "The sum of". • Source: "TotalIOT". Click the "Add an additional value" button. For the second information, select: • Display: "The sum of". • Source: "Quantity".