3 Replies Latest reply: Oct 14, 2017 12:20 PM by Ruben Marin RSS

    Qlik Sense pivot table measure and dimensions in columns

    Michael Simonsen

      Hi

      I have this pivot table with a column dimension: 7_scale_result.

       

      Skærmbillede 2017-10-14 kl. 11.20.07.png

      I want to add a column with a measure of average af 7_scale_result. I can make this table, but obviously i only need the total average column and not the average of each grade.

       

      Skærmbillede 2017-10-14 kl. 11.21.41.png

       

      Thanks in advance!

      Michael