Aggr Sum - problem

[#1]

Hi all,

i'm new in a Qlik Sense Community and I have one small problem with Qlik and function AGGR.

I try to show it on short example:

1. Tabel with parts order:

Part number	Order
A	50
B	100
C	25
D	50
E	75

2. Tabel with parts in groups:

Group	Part number
I	A
I	C
II	B
II	D
III	E

The case is, I'd like to say that part "A" is 66% of whole orders in group I and part "C" is 33% (for "A" 50/75 and for "C" 25/75)

The new table could look like below:

Group	Part number	share in %
I	A	33%
I	C	66%
II	B	66%
II	D	33%
III	E	100%

I'v try to solve it with function AGGR and SUM, but it didn't work. Maybe is another way or one of you had once problem like that?

Aggr(Sum(Order), Part number)/Aggr(Aggr(Sum(Order), Group)

Thank you guys a lot and I'm sorry 4 my English

Mateusz