terça-feira, 18 de agosto de 2020

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



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


Bom Dia/Boa Tarde/Boa Noite

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

DICAS 3036 - WINDEV TUTORIAL 59 - ESTATISTICAS - PIVOT - PVT  - PARTE C
Tutoriel WINDEV : Leçon 4.8.c. Statistique (champs Graphe et Tableau croisé dynamique) - TCD

ASSUNTOS

EXPLICANDO O QUE SERA FEITO
CRIANDO A GUIA PIVO 
CRIANDO A TABELA PIVO 
EXPLICANDO FONTES DE DADOS 
EXPLICANDO CONEXAO ENTRE ARQUIVOS
NO TOTALIZAR QUANTIDADE COLOCAR CAPTION LADO
TESTANDO O PIVO 



Video original da Franca

https://youtu.be/0DSyNBBynV0


Playlist Windev TUTORIAL











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 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".
        Pivot Table control creation wizard
      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.
      Pivot Table control creation wizard
      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.
      Pivot Table control creation wizard
    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.
        Pivot Table control creation wizard
      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 ( Save the element among the quick access buttons).

Test of Pivot Table control

  • Run the window test ( 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.
      Testing the window containing the Pivot Table control
  • 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: ".
      Describing the Pivot Table control
    4. Validate the description window.
    5. Run the window test again.


DICAS 2978 - WINDEV TUTORIAL 1 - 1.1B - WINDEV TEMA ESCURO E IDIOMA DO AMBIENTE
DICAS 2979 - WINDEV TUTORIAL 2 - 1.2- CRIAR JANELA E INSERIR TEXTO E EXIBIR
DICAS 2980 - WINDEV TUTORIAL 3 - 2.1- VARIAVEIS PARTE 1
DICAS 2981 - WINDEV TUTORIAL 4 - 2.2- VARIAVEIS ESCOPO - PARTE 2
DICAS 2982 - WINDEV TUTORIAL 5 - 2.1- VARIAVEIS OPERADORES PARTE 3
DICAS 2983 - WINDEV TUTORIAL 6 - 2.1.D - VARIAVEIS STRINGS PARTE 4
DICAS 2984 - WINDEV TUTORIAL 7 - 2.1.E - VARIAVEIS ARRAYS PARTE 5
DICAS 2985 - WINDEV TUTORIAL 8 - 2.2.A - CONDICOES IF-SWITCH PARTE 1
DICAS 2986 - WINDEV TUTORIAL 9 - 2.2.B - CONDICOES PARTE 2
DICAS 2987 - WINDEV TUTORIAL 10 - 2.3.A - LOOP PARTE 1
DICAS 2988 - WINDEV TUTORIAL 11 - 2.3.B - LOOP EXEMPLOS PARTE 2
DICAS 2989 - WINDEV TUTORIAL 12 - Lesson 2.4. The procedures - PARTE 1
DICAS 2990 - WINDEV TUTORIAL 13 - Leçon 2.4.b. Procedures Parametros - PARTE 2
DICAS 2991 - WINDEV TUTORIAL 14 - PROCEDURES REFERENCIA - PARTE 3
DICAS 2992 - WINDEV TUTORIAL 15 - PROCEDURES OPCIONAIS OU OBRIGATORIAS - PARTE 4
DICAS 2993 - WINDEV TUTORIAL 16 - PROCEDURES EXEMPLOS - PARTE 5
DICAS 2994 - WINDEV TUTORIAL 17 - PERGUNTAS E RESPOSTA - PARTE 1
DICAS 2995 - WINDEV TUTORIAL 18 - PERGUNTAS E RESPOSTA - PARTE 2
DICAS 2996 - WINDEV TUTORIAL 19 - WINDEV E OS BANCOS DE DADOS
DICAS 2997 - WINDEV TUTORIAL 20 - PROJETO E ANALISE - CRIACAO
DICAS 2998 - WINDEV TUTORIAL 21 - PROJETO E ANALISE - ARQUIVOS DADOS CLIENTE - PARTE 2
DICAS 2999 - WINDEV TUTORIAL 22 - PROJETO E ANALISE - ARQUIVOS DADOS CRIACAO ARQUIVO PEDIDO - PARTE 3
DICAS 3000 - WINDEV TUTORIAL 23 - PROJETO E ANALISE - IMPORTANDO CVS-ARQUIVO TEXTO - PARTE 4
DICAS 3001 - WINDEV TUTORIAL 24 - PROJETO E ANALISE - IMPORTANDO ARQUIVO PRODUTO - PARTE 5
DICAS 3002 - WINDEV TUTORIAL 25 - PROJETO E ANALISE - LINK - PARTE 6
DICAS 3003 - WINDEV TUTORIAL 26 - RAD COMPLETO
DICAS 3004 - WINDEV TUTORIAL 27 - VISAO GERAL
DICAS 3005 - WINDEV TUTORIAL 28 - Adicionar e Modificar Janelas PRODUTOS - PARTE A
DICAS 3006 - WINDEV TUTORIAL 29 - Adicionar e Modificar Janelas PRODUTOS Formulario - PARTE B
DICAS 3007 - WINDEV TUTORIAL 30 - Adicionar e Modificar Janelas PRODUTOS ALINHAR CAMPOS - PARTE C







Nenhum comentário:

Postar um comentário

Teste

Teste
teste