9 Replies Latest reply: Aug 31, 2017 8:53 AM by Sunny Talwar RSS

    Follow-up question Column totals in PivotTable

    Court van de Lisdonk

      Hello

       

      My first question about Column totals in PivotTable was answered by Sunny Talwar and helped me a lot. Thanks for that Sunny.

       

      In that PivotTable I have two expressions are Sum(LineAmount) and Sum(LineAmount)/Sum(TotalAmount)

      Problem is that Sum(LineAmount)/Sum(TotalAmount) gives always 100%.


      Cause
      is that LineAmount and Total Amount come from the same table and Total Amount is in fact Sum(LineAmount)


      Creating a new table with only dates and amounts didn't help a lot. And I hope someone can help with this problem.

      For data and other information, I refer to the first question I posted: Column totals in PivotTable in QlikView Layout & Visualizations

       

      Thanks in advance

       

      Regards Court