Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.