Tuto WINDEV 25

Part 4: Full application with data 237 9.  The products grouped by country must be displayed in the row headers . In the left section: • expand the Customer data file and double-click the Country item. • expand the Product data file and double-click Caption. Go to the next step. 10.  The wizard proposes a link for each row header (Customer.Country and Product.Caption). Validate each link and go to the next step. 11. Give a name to the Pivot Table control: PVT_Sales. 12. Validate the wizard. 13.  The Pivot Table control is automatically created in the window as well as a "Calculate" Button control. This Button control will allow the user to calculate the data to display in the Pivot Table control. This Button control can be positioned anywhere in the window. 14. Save the window ( among the quick access buttons). Testing the Pivot Table control ▶ Run the window test ( among the quick access buttons). 1. Click the "Pivot Table" tab pane, then the "Calculate" control. Remark CAUTION: The calculation time depends on the size of the database and on the number of row and column headers. The result of the pivot table can be saved to avoid re-calculating at each interrogation.