2 Replies Latest reply: Jul 26, 2012 10:28 AM by Alfredo González RSS

    calculating totals in  pivot table

      hello everyone, i have  an issue with QlikView.

       

      i have a pivot table with the next expression:

       

      if(Column(2) >= 1,(SUM(Venta * REBATE_NORMAL))/1000,0)

       

      and this brings me the next results:

       

       

      this results are correct except for the total. it should give me this total 43.41.

       

      is there a way to qlikview calculate the total correctly in a pivot table. i know  you can change the totals in a straight table but in this particular case its need to be a pivot table.

       

       

      thanks in advance

       

      Best regards.