3 Replies Latest reply: Jul 16, 2015 8:27 AM by rafael scalabrin RSS

    dynamic table (tabela dinamica)

    rafael scalabrin

      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