5 Replies Latest reply: Sep 18, 2013 5:34 AM by Vishwaranjan Kumar RSS

    average of Pivot partial sums

      Hey!

       

      I'm new in qlikview and my english is not really good - so, first of all: sorry!

       

      My problem is the following:

       

      I have different departments with different number of employees.

      Now i want to have in the column "Total" the average of all month and not the total number.

      I'm using a Pivot table in qlikview!

       

      DepartmentJanFebMarAprMayTotal
      A5238321
      B2142312
      C3181114
      Total1041511747

       

      Does anybody know what to do?

       

      Thanks and best regards!