This content has been marked as final. Show 2 replies
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
I hope anyone can help me.