Sum of aggregate by dimension

[juriengroot]

    This is my source data:

Order ID	Value A	Value B
A	2	6
B	5	4
B	5	2
C	1	5
C	1	5
C	1	4
D	6	8

I want my result table in Qlik Sense to be:

Order ID	Distinct Sum Value A	SUM Value B
A	2	6
B	5	6
C	1	14
D	6	8
Total	14	34

I tried everything with Aggr, Distinct and Sum, but haven't succeeded yet. Who can point me in the right direction? I would be very grateful!

[juriengroot]

Thanks, unfortunately in the complete dataset, values are not always unique. See above my comments to Sunny for more details.

[sunny_talwar]

May be use Dimensionality() function here:

How to use - Dimensionality()

The second dimension... or how to use secondarydimensionality()