How to model this ?

edemerdjieva — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: How to model this ?

Yoichi_Hirotake — Tue, 02 Jul 2019 23:27:04 GMT

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