Sum up correct on Grand Total

[Anonymous]

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

[MK_QSL · Accepted solution]

SUM(Aggr(SUM(Target)/Count(Distinct SC_ID),ID,Group))

[Anonymous]

Great! Seems to work.

Thanks a lot!