2 Replies Latest reply: Jun 14, 2017 8:56 AM by Thomas Ødegaard RSS

    Sum up correct on Grand Total

    Thomas Ødegaard

      Hi,

       

      I have an issue in Qlik Sense with my measure to sum up correct on Grand Total.

      My Target data is only on Group level, so I have to divide my sum measure with number of distinct SC_ID to avoid it to show the wrong figures. However, this leads to a wrong calculation on Total level.

       

      In the example attached the right numbers should be

      ID          Group          Measure

      AAA      External      19650

      AAA      Business     7350

      AAA      Internal        11100

      Total                         38100


      I hope anyone can help me.

       

      Br,

      Thomas