Load Script Query

[dmac1971]

Lets say I have a cross table with my customers and their monthly targets :

Customer	Jan-14	Feb-14	Mar-14	Apr-14	May-14	Jun-14	Jul-14	Aug-14	Sep-14	Oct-14	Nov-14	Dec-14
Customer 1	100	120	100	120	120	100	120	120	100	120	100	120
Customer 2	250	250	250	250	250	250	250	250	250	250	250	250
Customer 3	250	350	250	350	250	350	400	350	300	250	250	250

Then I have my customers and their sales :

Customer	Date	Item	Desc	Qty	Sales	Category
Customer 1	01/01/2014	1.1.2	Flag	1	50	Cloth
Customer 1	01/02/2014	1.1.3	Pole	2	100	Wood
Customer 2	01/02/2014	1.1.2	Flag	3	150	Cloth
Customer 2	02/03/2014	1.1.3	Pole	2	100	Wood
Customer 3	04/06/2014	1.1.2	Flag	3	150	Cloth
Customer 1	04/06/2014	1.1.3	Pole	1	50	Wood
Customer 2	04/06/2014	1.1.2	Flag	2	100	Cloth
Customer 3	12/09/2014	1.1.3	Pole	3	150	Wood
Customer 3	12/09/2014	1.1.3	Pole	2	100	Wood
Customer 1	01/01/2014	1.1.2	Flag	1	50	Cloth
Customer 1	01/03/2014	1.1.3	Pole	2	100	Wood
Customer 2	01/02/2014	1.1.2	Flag	3	150	Cloth
Customer 2	02/04/2014	1.1.3	Pole	2	100	Wood
Customer 3	04/01/2014	1.1.2	Flag	3	150	Cloth
Customer 1	04/01/2014	1.1.3	Pole	1	50	Wood
Customer 2	04/03/2014	1.1.2	Flag	2	100	Cloth
Customer 3	12/05/2014	1.1.3	Pole	3	150	Wood
Customer 3	12/06/2014	1.1.3	Pole	2	100	Wood

I need to link both the Month-Year field and the customer field together, resulting in synthetic keys, is there a way I can get around this as with a bit data set its causing loops.

[stabben23]

Hi,

you will have to use both field (Customer & Month-Year) as key. You will also have to get these 2 tabels at the same level. One way is to make a datefield of Month-Year, like 01/01/2014. Or you can aggregate the sales data on Month-Year level.