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.