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



      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%.

      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