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 Pivot Table control creation wizard 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".
  Go to the next step.
6. The years must be displayed in the column headers. On the left, expand the Orders data file and double-click the Date item.
  Go to the next step.
7. The wizard proposes a link to reach the Orders data file and it proposes to display three levels of information in header: the years, the quarters and the months.
8. Go to the next step.
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. In the following steps, 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).

Test of 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 recalculating on each request.
2. Click the "+" signs to expand the different columns and rows.

Stop the test. We will make a small improvement in this Pivot Table control. Indeed, nothing indicates that one of the numbers in the cells corresponds to a quantity. We are going to use a specific display mask for this value.

To use a display mask in a cell:
1. Open the description of the Pivot Table control (double-click the control).
2. In the "Content" tab, click "VAL_NoName2". The description of values displayed in the cells appears.
3. In the "Mask" area, add the prefix "Qt: ".
4. Validate the description window.
5. Run the window test again.

DICAS 3008 - WINDEV TUTORIAL 31 - Adicionar e Modificar Janelas ANCORAS - PARTE D
DICAS 3009 - WINDEV TUTORIAL 32-Adicionar e Modificar Janelas - Exibicao registro - PARTE E

DICAS 3010 - WINDEV TUTORIAL 33-Adicionar e Modificar Janelas - Modifica Imagen - PARTE F

DICAS 3011 - WINDEV TUTORIAL 34 - Adicionar e Modificar Janelas - Validacao - PARTE G

DICAS 3012 - WINDEV TUTORIAL 35 - Adicionar e Modificar Janelas - CRIACAO - PARTE H

DICAS 3013 - WINDEV TUTORIAL 36 - Adicionar e Modificar Janelas - Teste - PARTE I

DICAS 3014 - WINDEV TUTORIAL 37 - Pesquisa Simples - Apresentacao - PARTE A

DICAS 3015 - WINDEV TUTORIAL 38 - Pesquisa Simples - Usando Controle Tab- PARTE B

DICAS_3016_WINDEV_TUTORIAL_39_Pesquisa_Simples_Configurando_Pesquisa_PARTE_C

DICAS 3017 - WINDEV TUTORIAL 40 - Pesquisa Simples - Pesquisa Identica- PARTE D

DICAS 3018 - WINDEV TUTORIAL 41 - Pesquisa Simples - Pesquisa Generica - PARTE E

DICAS 3019 - WINDEV TUTORIAL 42 - Pesquisa Simples - Navegacao pelos Arquivos - PARTE F

DICAS 3020 - WINDEV TUTORIAL 43 - Pesquisa Multicriterio - Apresentacao - Parte A

DICAS 3021 - WINDEV TUTORIAL 44 - Pesquisa Multicriterio - Criacao Consulta - Parte B

DICAS 3022 - WINDEV TUTORIAL 45 - Pesquisa Multicriterio - Uso Parametro - Parte C

DICAS 3023 - WINDEV TUTORIAL 46 - Pesquisa Multicriterio - Criando Interface - Parte D

DICAS 3024 - WINDEV TUTORIAL 47 - Pesquisa Multicriterio - Primeiro Parametro - Parte E

DICAS 3025 - WINDEV TUTORIAL 48 - Pesquisa Multicriterio - Segundo Parametro - Parte F

DICAS 3026 - WINDEV TUTORIAL 49 - Pesquisa Multicriterio - Parametro Data - Parte G

DICAS 3027 - WINDEV TUTORIAL 50 - IMPRIMIR_TABELA

DICAS 3028 - WINDEV TUTORIAL 51 - IMPRIMIR PEDIDO-CRIACAO RELATORIO - PARTE A

DICAS 3029 - WINDEV TUTORIAL 52 - IMPRIMIR PEDIDO - CRIAR O RELATORIO BASE QUERY - PARTE B

DICAS 3030 - WINDEV TUTORIAL 53 - IMPRIMIR PEDIDO - ALTERACOES RELATORIO - PARTE C

DICAS 3031 - WINDEV TUTORIAL 54 - IMPRIMIR PEDIDO - MENU RELATORIO - PARTE D

DICAS 3032 - WINDEV TUTORIAL 55 - RELATORIO LISTA CLIENTE - PARTE A

DICAS 3033 - WINDEV TUTORIAL 56 - RELATORIO CLIENTE - Imprimir - PARTE B

DICAS 3034 - WINDEV TUTORIAL 57 - ESTATISTICAS GRAFICO PIVOT - QUERY ANO - PARTE A

DICAS 3035 - WINDEV TUTORIAL 58 - ESTATISTICAS GRAFICO PIVOT - GRAFICO-PARTE B

DICAS 3036 - WINDEV TUTORIAL 59 - ESTATISTICAS - PIVOT - PVT - PARTE C

DICAS 3037 - WINDEV TUTORIAL 60 - ENVIAR EMAIL - ADICIONANDO CAMPOS - PARTE A

Páginas

terça-feira, 18 de agosto de 2020

DICAS 3036 - WINDEV TUTORIAL 59 - ESTATISTICAS - PIVOT - PVT - PARTE C

https://youtu.be/ZxjU8Ab-3Ws

Esse Ao Vivo vai estrear as 14:00 do dia 28/08/2020

https://youtu.be/0DSyNBBynV0

Nenhum comentário:

Postar um comentário


	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 recalculating on each request.