6 Replies Latest reply: Dec 28, 2017 1:35 PM by Sunny Talwar RSS

    Show Total and Average in pivot table or straight table

    Matt McIlvride

      I would like to create a table that displays information like this:

       

      EmployeeCalls MadeSales MadeSales from Calls
      Average10438.61%
      Total3012---
      Annie

      10

      220.00%
      Bianca12758.33%
      Charlie8337.50%

       

      This is a simple task in Excel, but I cannot figure out how to do this in Qlik Sense. There are several challenges here:

      • The most important thing is that there doesn't seem to be an option to do multiple totals lines, one for Total and one for Average. Is there a function I can use to achieve this instead?
      • Pivot tables are cleaner and work better for what I am trying to do, but don't let you turn Total off per column when it isn't appropriate, like in the percentage table above. Is there a way around this in pivot tables, or do I need to use a straight table?