Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Please post on English
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.
Thats it, thank you settu_periasamy.