Hi,
I am currently working with a crosstab function trying to produce a table containing the amount of sales that are INVOICED, PART PAYMENT, OVERDUE within a WEEK NO that is within a PERIOD.
Firstly, I need the ability to define the following parameters;
PERIOD 1 WEEK 1 = between 04/04/2010 to 10/04/2010
--""-----WEEK 2 = between 11/04/2010 to 17/04/2010
--""-----WEEK 3 = between 18/04/2010 to 24/04/2010
--""-----WEEK 4 = between 25/04/2010 to 01/05/2010
PERIOD 2 WEEK 1 = between 02/05/2010 to 08/05/2010
PERIOD 3 WEEK 1 = between 30/05/2010 to 05/06/2010
All data is contained in a single table.
05/04/2010 PART PAYMENT
24/04/2010 INVOICED
25/04/2010 INVOICED
15/05/2010 INVOICED
16/06/2010 OVERDUE
and so on...
I need a to create a crosstab table that produces the following table;
PERIOD---WEEK---INVOICED---PART PAYMENT---OVERDUE
--01------01-------01----------00-----------00---
--01------03-------02----------00-----------00---
--02------02-------01----------00-----------00---
--03------03-------00----------00-----------01---
I have looked at the week() function, but it defines week 1 from the 1st Jan. I need it to start from the 1st day of our financial year (04/04/2010)
Does anyone know how I may achieve this?
Thanks,
Denis
I am currently working with a crosstab function trying to produce a table containing the amount of sales that are INVOICED, PART PAYMENT, OVERDUE within a WEEK NO that is within a PERIOD.
Firstly, I need the ability to define the following parameters;
PERIOD 1 WEEK 1 = between 04/04/2010 to 10/04/2010
--""-----WEEK 2 = between 11/04/2010 to 17/04/2010
--""-----WEEK 3 = between 18/04/2010 to 24/04/2010
--""-----WEEK 4 = between 25/04/2010 to 01/05/2010
PERIOD 2 WEEK 1 = between 02/05/2010 to 08/05/2010
PERIOD 3 WEEK 1 = between 30/05/2010 to 05/06/2010
All data is contained in a single table.
05/04/2010 PART PAYMENT
24/04/2010 INVOICED
25/04/2010 INVOICED
15/05/2010 INVOICED
16/06/2010 OVERDUE
and so on...
I need a to create a crosstab table that produces the following table;
PERIOD---WEEK---INVOICED---PART PAYMENT---OVERDUE
--01------01-------01----------00-----------00---
--01------03-------02----------00-----------00---
--02------02-------01----------00-----------00---
--03------03-------00----------00-----------01---
I have looked at the week() function, but it defines week 1 from the 1st Jan. I need it to start from the 1st day of our financial year (04/04/2010)
Does anyone know how I may achieve this?
Thanks,
Denis