How to model this ?

[edemerdjieva]

Hello all,

I develop a report for the follow-up loyalty accounts per store (KPIs = number of loyalty points earned, number of loyalty points used).

Here are the relations between data :

1 store generates -> N loyalty movements (NN loyalty points per movement)

1 loyalty movement = 1 loyalty card = 1 store of loyalty card issue

Raw data:

Store generating loyalty movement	Store of creation of loyalty card	Movement code	Qty moved
S.1	045	AA	5
S.2	045	BB	13
S.18	045	CC	80
S.1	013	DD	60

Result expected:

Store of creation of loyalty card	Number of loyalty points
045	98
013	60

Result obtained:

Store of creation of loyalty card	Number of loyalty points
045	5
045	13
045	80
013	60

Thank you in advance.

[Yoichi_Hirotake]

This can be done without manipulating data model. Sample attached. Hope this will be the help.