6 Replies Latest reply: Feb 26, 2016 2:16 AM by kishore pandurangan RSS

    Creating a Pivot Table

    Ridhaa Hendricks

      Hi There

       

      I am trying to create a pivot table and using the totals from the expression I would like to do a calculation

      what would be the simplest way to do this.

       

          Total is the Partial sums of the dimension "Factory" , Total Prediction is the total/1*12 , for Docs (2000/1*12=24000)

      how can I do this in Qlikview ?

         

      SupplierShop 1Shop 2Shop 3Shop 5TotalTotal Prediction
      Docs2000200024000
      Ottos1000100012000
      Peoples3000300036000
      Peters Paper4000400048000
      Vans1000100012000
      Williams Plastics5000500060000

       

      Your assistance is appreciated.