dynamic table (tabela dinamica)

[rafael5958]

I have a table in Excel that is something like this:

Position Name Value Line Expense

1 Joao Vale 100

2 Joao Trans 20

3 B C Paul Valley 400

4 Carlos Trans X 20

5 B Y Pedro Valley 400

I want to make a dynamic table that expand the office, then the name, Expense and put the total at the end. How do I do that ??? Something like:

The Joao Vale 100

                       behind 20

                        total: 120

        ----------------------------

        Charles X trans 20

                                total 20

----------------------------------------

B Paul Vale C 400

                            Total 400

      --------------------------------------

      Prdro Y Valley 400

                   Total 400

Translated with Google Translate - Qlik Community Administrative Team

Tenho uma tabela no excel que é mais ou menos assim:

Linha Cargo     Nome         Despesa     Valor

1        A          Joao A        Vale          100

2        A          Joao A       Trans          20                                      

3        B        Paulo C       Vale            400

4        A          Carlos X       Trans          20                                      

5        B        Pedro Y       Vale            400

Quero fazer uma tabela dinamica que expanda O cargo, depois o Nome, Despesa e coloque o total no final. Como faço isso??? Algo tipo:

A     Joao A     Vale   100

                      tras    20

                       total: 120

       ----------------------------

       Carlos X     trans 20

                               total 20

----------------------------------------

B   Paulo C     Vale   400

                           total 400

     --------------------------------------

     Prdro Y   Vale   400

                  total 400

[#2]

Please post on English

[settu_periasamy · Accepted solution]

Hi,

Do you want like the below?

Script:

Table:
LOAD * INLINE [
    Linha, Cargo, Nome, Despesa, Valor
    1, A, Joao A, Vale, 100
    2, A, Joao A, Trans, 20
    3, B, Paulo C, Vale, 400
    4, A, Carlos X, Trans, 20
    5, B, Pedro Y, Vale, 400
];

Create the Pivot table.

Add the dimension like the below

In the Expression

in the presentation

Hope this helps.

[rafael5958]

Thats it, thank you settu_periasamy.