Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All
Please note according to the expressions that is applied currently, the cumulative months of business done is shown.
Current expressions applied: =(max(MARKETING_DATE) - (Opening_Date))/30
Achieved result :
M3 | M3 | M3 | ||||
SCCOD | SCNAME | Opening_Date | YEAR | sales | No_Of_Month | Avg_Sales |
01 | P | 10-Nov-2014 | 2014 | 26,669 | 2 | 16,328 |
10-Nov-2014 | 2015 | 187,080 | 14 | 13,491 | ||
10-Nov-2014 | 2016 | 230,062 | 26 | 8,826 | ||
10-Nov-2014 | 2017 | 189,387 | 32 | 5,987 | ||
10-Nov-2014 | Total | 633,199 | 32 | 20,017 |
My requirement is to arrive at the number of months relevant to a particular year. Hence kindly advise me the expressions to be applied in this respect.
Required result:
M3 | M3 | M3 | ||||
SCCOD | SCNAME | Opening_Date | YEAR | sales | No_Of_Month | Avg_Sales |
01 | P | 10-Nov-2014 | 2014 | 26,669 | 2 | 16,328 |
10-Nov-2014 | 2015 | 187,080 | 12 | 15,590 | ||
10-Nov-2014 | 2016 | 230,062 | 12 | 19,172 | ||
10-Nov-2014 | 2017 | 189,387 | 6 | 31,565 | ||
10-Nov-2014 | Total | 633,199 | 32 | 20,017 |
MY SCRIPT GIVEN BELOW
LOAD BCOD,
CLA_CODE,
PRD_CODE,
POLICY_NO,
REF_NO,
DATE(floor(MARKETING_DATE)) as MARKETING_DATE,
// DATE(monthstart(MARKETING_DATE), 'MM-YYYY') as MonthYear,
MDATE,
YEAR,
MONTH,
NAME,
ME_CODE,
//TRN_DATE,
// DATE(floor(TRN_DATE)) as TRN_DATE,
DATE(Floor(MonthStart(MakeDate(YEAR,MONTH)))) as TRAN_DATE,
TRAN_YEAR,
TRAN_MONTH,
POL_PERIOD_FROM,
SCCOD,
CP,
RS,
TC,
GROSSTOT,
TYPE,
N_R_NOS1,
F_NOS2
FROM
G:\qlickviwe\Sales\SALES2014.QVD
(qvd);
LOAD DATE(STARTING_DATE,'DD-MMM-YYYY')as Opening_Date ,
SCCOD,
SCNAME,
SCADDRESS,
ME,
//BCOD,
STATUS
FROM
G:\code\Convenient_Centre_Master.xls
(biff, embedded labels, table is Sheet1$);
Pls Help
sagara
Kindly share the sample data.
Regards,
Kaushik Solanki
Front End / Back end?
SCCOD | SCNAME | Opening_Date | YEAR | MONTH | AC_NO | BCOD | CLASS | MARKETING_DATE | Data |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 11 | CO22 | MOTOR_TP | 11 Nov 2014 | 2,167 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 11 | CO22 | MOTOR_TP | 13 Nov 2014 | 1,320 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 11 | CO22 | MOTOR_TP | 14 Nov 2014 | 947 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 11 | CO22 | MOTOR_TP | 15 Nov 2014 | 473 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 11 | CO22 | MOTOR_TP | 17 Nov 2014 | 947 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 11 | CO22 | MOTOR_TP | 19 Nov 2014 | 1,320 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 11 | CO22 | MOTOR_TP | 20 Nov 2014 | 473 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 11 | CO22 | MOTOR_TP | 21 Nov 2014 | 473 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 11 | CO22 | MOTOR_TP | 22 Nov 2014 | 473 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 11 | CO22 | MOTOR_TP | 24 Nov 2014 | 473 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 11 | CO22 | MOTOR_TP | 25 Nov 2014 | 542 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 11 | CO22 | MOTOR_TP | 26 Nov 2014 | 1,694 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 11 | CO22 | MOTOR_TP | 27 Nov 2014 | 542 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 11 | CO22 | MOTOR_TP | 28 Nov 2014 | 947 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 12 | CO22 | MOTOR_TP | 01 Dec 2014 | 473 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 12 | CO22 | MOTOR_TP | 03 Dec 2014 | 1,015 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 12 | CO22 | MOTOR_TP | 04 Dec 2014 | 473 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 12 | CO22 | MOTOR_TP | 05 Dec 2014 | 473 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 12 | CO22 | MOTOR_TP | 09 Dec 2014 | 2,404 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 12 | CO22 | MOTOR_TP | 10 Dec 2014 | 847 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 12 | CO22 | MOTOR_TP | 12 Dec 2014 | 1,420 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 12 | CO22 | MOTOR_TP | 15 Dec 2014 | 1,015 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 12 | CO22 | MOTOR_TP | 16 Dec 2014 | 542 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 12 | CO22 | MOTOR_TP | 17 Dec 2014 | 1,015 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 12 | CO22 | MOTOR_TP | 18 Dec 2014 | 847 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 12 | CO22 | MOTOR_TP | 22 Dec 2014 | 1,015 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 12 | CO22 | MOTOR_TP | 23 Dec 2014 | 473 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | 12 | CO22 | MOTOR_TP | 29 Dec 2014 | 1,862 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2014 | Total | 26,669 | ||||
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 01 | CO22 | MOTOR_TP | 03 Jan 2015 | 856 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 01 | CO22 | MOTOR_TP | 05 Jan 2015 | 1,813 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 01 | CO22 | MOTOR_TP | 06 Jan 2015 | 1,027 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 01 | CO22 | MOTOR_TP | 07 Jan 2015 | 478 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 01 | CO22 | MOTOR_TP | 13 Jan 2015 | 1,027 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 01 | CO22 | MOTOR_TP | 16 Jan 2015 | 1,646 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 01 | CO22 | MOTOR_TP | 19 Jan 2015 | 2,868 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 01 | CO22 | MOTOR_TP | 20 Jan 2015 | 1,405 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 01 | CO22 | MOTOR_TP | 21 Jan 2015 | 1,813 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 01 | CO22 | MOTOR_TP | 23 Jan 2015 | 956 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 01 | CO22 | MOTOR_TP | 27 Jan 2015 | 478 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 01 | CO22 | MOTOR_TP | 28 Jan 2015 | 1,027 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 01 | CO22 | MOTOR_TP | 29 Jan 2015 | 478 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 01 | CO22 | MOTOR_TP | 30 Jan 2015 | 549 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 02 | CO22 | MOTOR_TP | 02 Feb 2015 | 956 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 02 | CO22 | MOTOR_TP | 05 Feb 2015 | 956 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 02 | CO22 | MOTOR_TP | 06 Feb 2015 | 478 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 02 | CO22 | MOTOR_TP | 07 Feb 2015 | 478 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 02 | CO22 | MOTOR_TP | 09 Feb 2015 | 478 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 02 | CO22 | MOTOR_TP | 10 Feb 2015 | 478 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 02 | CO22 | MOTOR_TP | 11 Feb 2015 | 478 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 02 | CO22 | MOTOR_TP | 13 Feb 2015 | 478 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 02 | CO22 | MOTOR_TP | 14 Feb 2015 | 3,895 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 02 | CO22 | MOTOR_TP | 16 Feb 2015 | 6,494 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 02 | CO22 | MOTOR_TP | 17 Feb 2015 | 478 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 02 | CO22 | MOTOR_TP | 18 Feb 2015 | 478 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 02 | CO22 | MOTOR_TP | 19 Feb 2015 | 5,737 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 02 | CO22 | MOTOR_TP | 20 Feb 2015 | 1,912 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 02 | CO22 | MOTOR_TP | 24 Feb 2015 | 549 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 02 | CO22 | MOTOR_TP | 25 Feb 2015 | 956 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 02 | CO22 | MOTOR_TP | 26 Feb 2015 | 1,813 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 02 | CO22 | MOTOR_TP | 27 Feb 2015 | 956 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 03 | CO22 | MOTOR_TP | 02 Mar 2015 | 478 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 03 | CO22 | MOTOR_TP | 03 Mar 2015 | 2,531 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 03 | CO22 | MOTOR_TP | 04 Mar 2015 | 1,097 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 03 | CO22 | MOTOR_TP | 06 Mar 2015 | 956 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 03 | CO22 | MOTOR_TP | 09 Mar 2015 | 1,097 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 03 | CO22 | MOTOR_TP | 10 Mar 2015 | 2,939 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 03 | CO22 | MOTOR_TP | 11 Mar 2015 | 956 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 03 | CO22 | MOTOR_TP | 12 Mar 2015 | 1,575 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 03 | CO22 | MOTOR_TP | 14 Mar 2015 | 549 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 03 | CO22 | MOTOR_TP | 17 Mar 2015 | 478 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 03 | CO22 | MOTOR_TP | 18 Mar 2015 | 549 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 03 | CO22 | MOTOR_TP | 19 Mar 2015 | 856 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 03 | CO22 | MOTOR_TP | 20 Mar 2015 | 1,983 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 03 | CO22 | MOTOR_TP | 21 Mar 2015 | 549 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 03 | CO22 | MOTOR_TP | 23 Mar 2015 | 956 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 03 | CO22 | MOTOR_TP | 24 Mar 2015 | 1,027 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 03 | CO22 | MOTOR_TP | 25 Mar 2015 | 856 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 03 | CO22 | MOTOR_TP | 26 Mar 2015 | 1,434 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 03 | CO22 | MOTOR_TP | 27 Mar 2015 | 478 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 03 | CO22 | MOTOR_TP | 30 Mar 2015 | 1,813 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 03 | CO22 | MOTOR_TP | 31 Mar 2015 | 2,390 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 04 | CO22 | MOTOR_TP | 02 Apr 2015 | 1,335 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 04 | CO22 | MOTOR_TP | 06 Apr 2015 | 1,505 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 04 | CO22 | MOTOR_TP | 07 Apr 2015 | 478 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 04 | CO22 | MOTOR_TP | 08 Apr 2015 | 2,531 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 04 | CO22 | MOTOR_TP | 09 Apr 2015 | 478 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 04 | CO22 | MOTOR_TP | 10 Apr 2015 | 478 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 04 | CO22 | MOTOR_TP | 11 Apr 2015 | 3,047 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 04 | CO22 | MOTOR_TP | 17 Apr 2015 | 1,912 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 04 | CO22 | MOTOR_TP | 20 Apr 2015 | 1,434 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 04 | CO22 | MOTOR_TP | 21 Apr 2015 | 956 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 04 | CO22 | MOTOR_TP | 27 Apr 2015 | 1,405 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 04 | CO22 | MOTOR_TP | 28 Apr 2015 | 956 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 04 | CO22 | MOTOR_TP | 29 Apr 2015 | 1,434 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 04 | CO22 | MOTOR_TP | 30 Apr 2015 | 478 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 05 | CO22 | MOTOR_TP | 05 May 2015 | 549 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 05 | CO22 | MOTOR_TP | 06 May 2015 | 856 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 05 | CO22 | MOTOR_TP | 07 May 2015 | 956 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 05 | CO22 | MOTOR_TP | 08 May 2015 | 856 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 05 | CO22 | MOTOR_TP | 11 May 2015 | 1,097 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 05 | CO22 | MOTOR_TP | 13 May 2015 | 522 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 05 | CO22 | MOTOR_TP | 14 May 2015 | 522 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 05 | CO22 | MOTOR_TP | 15 May 2015 | 1,593 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 05 | CO22 | MOTOR_TP | 19 May 2015 | 856 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 05 | CO22 | MOTOR_TP | 20 May 2015 | 1,071 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 05 | CO22 | MOTOR_TP | 22 May 2015 | 1,044 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 05 | CO22 | MOTOR_TP | 25 May 2015 | 1,566 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 05 | CO22 | MOTOR_TP | 26 May 2015 | 1,071 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 05 | CO22 | MOTOR_TP | 27 May 2015 | 1,044 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 05 | CO22 | MOTOR_TP | 28 May 2015 | 522 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 06 | CO22 | MOTOR_TP | 01 Jun 2015 | 1,379 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 06 | CO22 | MOTOR_TP | 04 Jun 2015 | 1,593 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 06 | CO22 | MOTOR_TP | 05 Jun 2015 | 549 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 06 | CO22 | MOTOR_TP | 08 Jun 2015 | 522 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 06 | CO22 | MOTOR_TP | 09 Jun 2015 | 549 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 06 | CO22 | MOTOR_TP | 11 Jun 2015 | 1,071 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 06 | CO22 | MOTOR_TP | 16 Jun 2015 | 522 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 06 | CO22 | MOTOR_TP | 17 Jun 2015 | 522 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 06 | CO22 | MOTOR_TP | 19 Jun 2015 | 1,097 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 06 | CO22 | MOTOR_TP | 20 Jun 2015 | 549 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 06 | CO22 | MOTOR_TP | 22 Jun 2015 | 549 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 06 | CO22 | MOTOR_TP | 23 Jun 2015 | 1,566 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 06 | CO22 | MOTOR_TP | 25 Jun 2015 | 856 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 06 | CO22 | MOTOR_TP | 26 Jun 2015 | 1,901 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 06 | CO22 | MOTOR_TP | 29 Jun 2015 | 2,690 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 06 | CO22 | MOTOR_TP | 30 Jun 2015 | 1,566 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 07 | CO22 | MOTOR_TP | 02 Jul 2015 | 1,954 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 07 | CO22 | MOTOR_TP | 03 Jul 2015 | -1,813 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 07 | CO22 | MOTOR_TP | 06 Jul 2015 | 1,044 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 07 | CO22 | MOTOR_TP | 07 Jul 2015 | 522 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 07 | CO22 | MOTOR_TP | 08 Jul 2015 | 549 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 07 | CO22 | MOTOR_TP | 09 Jul 2015 | 522 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 07 | CO22 | MOTOR_TP | 10 Jul 2015 | 1,071 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 07 | CO22 | MOTOR_TP | 13 Jul 2015 | 1,619 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 07 | CO22 | MOTOR_TP | 15 Jul 2015 | 522 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 07 | CO22 | MOTOR_TP | 16 Jul 2015 | 522 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 07 | CO22 | MOTOR_TP | 17 Jul 2015 | -478 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 07 | CO22 | MOTOR_TP | 21 Jul 2015 | 1,071 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 07 | CO22 | MOTOR_TP | 23 Jul 2015 | 1,619 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 07 | CO22 | MOTOR_TP | 24 Jul 2015 | 522 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 07 | CO22 | MOTOR_TP | 27 Jul 2015 | 593 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 07 | CO22 | MOTOR_TP | 29 Jul 2015 | 522 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 08 | CO22 | MOTOR_TP | 03 Aug 2015 | 593 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 08 | CO22 | MOTOR_TP | 05 Aug 2015 | 566 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 08 | CO22 | MOTOR_TP | 06 Aug 2015 | 593 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 08 | CO22 | MOTOR_TP | 10 Aug 2015 | 900 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 08 | CO22 | MOTOR_TP | 11 Aug 2015 | 593 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 08 | CO22 | MOTOR_TP | 14 Aug 2015 | 1,216 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 08 | CO22 | MOTOR_TP | 26 Aug 2015 | 566 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 08 | CO22 | MOTOR_TP | 31 Aug 2015 | 593 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 09 | CO22 | MOTOR_TP | 01 Sep 2015 | 566 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 09 | CO22 | MOTOR_TP | 03 Sep 2015 | 1,132 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 09 | CO22 | MOTOR_TP | 04 Sep 2015 | 593 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 09 | CO22 | MOTOR_TP | 09 Sep 2015 | 566 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 09 | CO22 | MOTOR_TP | 10 Sep 2015 | 566 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 09 | CO22 | MOTOR_TP | 11 Sep 2015 | 566 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 09 | CO22 | MOTOR_TP | 16 Sep 2015 | 1,159 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 09 | CO22 | MOTOR_TP | 17 Sep 2015 | 900 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 09 | CO22 | MOTOR_TP | 21 Sep 2015 | 1,211 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 09 | CO22 | MOTOR_TP | 22 Sep 2015 | 592 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 09 | CO22 | MOTOR_TP | 24 Sep 2015 | 592 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 09 | CO22 | MOTOR_TP | 28 Sep 2015 | 619 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 09 | CO22 | MOTOR_TP | 29 Sep 2015 | 592 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 10 | CO22 | MOTOR_TP | 01 Oct 2015 | 592 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 10 | CO22 | MOTOR_TP | 02 Oct 2015 | 619 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 10 | CO22 | MOTOR_TP | 05 Oct 2015 | 592 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 10 | CO22 | MOTOR_TP | 06 Oct 2015 | 619 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 10 | CO22 | MOTOR_TP | 07 Oct 2015 | 927 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 10 | CO22 | MOTOR_TP | 08 Oct 2015 | 1,185 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 10 | CO22 | MOTOR_TP | 09 Oct 2015 | 619 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 10 | CO22 | MOTOR_TP | 12 Oct 2015 | 1,185 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 10 | CO22 | MOTOR_TP | 20 Oct 2015 | 619 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 10 | CO22 | MOTOR_TP | 21 Oct 2015 | 1,211 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 10 | CO22 | MOTOR_TP | 22 Oct 2015 | 592 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 10 | CO22 | MOTOR_TP | 23 Oct 2015 | 1,211 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 10 | CO22 | MOTOR_TP | 28 Oct 2015 | 1,519 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 10 | CO22 | MOTOR_TP | 29 Oct 2015 | 619 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 11 | CO22 | MOTOR_TP | 03 Nov 2015 | 1,211 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 11 | CO22 | MOTOR_TP | 05 Nov 2015 | 927 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 11 | CO22 | MOTOR_TP | 06 Nov 2015 | 592 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 11 | CO22 | MOTOR_TP | 09 Nov 2015 | 1,185 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 11 | CO22 | MOTOR_TP | 11 Nov 2015 | 2,138 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 11 | CO22 | MOTOR_TP | 14 Nov 2015 | 592 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 11 | CO22 | MOTOR_TP | 16 Nov 2015 | 592 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 11 | CO22 | MOTOR_TP | 17 Nov 2015 | 592 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 11 | CO22 | MOTOR_TP | 19 Nov 2015 | 619 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 11 | CO22 | MOTOR_TP | 23 Nov 2015 | 6,517 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 11 | CO22 | MOTOR_TP | 24 Nov 2015 | 1,211 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 11 | CO22 | MOTOR_TP | 26 Nov 2015 | 619 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 11 | CO22 | MOTOR_TP | 30 Nov 2015 | 1,519 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 12 | CO22 | MOTOR_TP | 01 Dec 2015 | 619 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 12 | CO22 | MOTOR_TP | 04 Dec 2015 | 1,211 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 12 | CO22 | MOTOR_TP | 08 Dec 2015 | 927 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 12 | CO22 | MOTOR_TP | 09 Dec 2015 | 1,519 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 12 | CO22 | MOTOR_TP | 11 Dec 2015 | 619 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 12 | CO22 | MOTOR_TP | 16 Dec 2015 | 619 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 12 | CO22 | MOTOR_TP | 17 Dec 2015 | 2,473 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 12 | CO22 | MOTOR_TP | 18 Dec 2015 | 1,211 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 12 | CO22 | MOTOR_TP | 22 Dec 2015 | 592 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | 12 | CO22 | MOTOR_TP | 31 Dec 2015 | 1,185 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2015 | Total | 187,080 | ||||
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 01 | CO22 | MOTOR_TP | 04 Jan 2016 | 1,248 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 01 | CO22 | MOTOR_TP | 11 Jan 2016 | 1,621 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 01 | CO22 | MOTOR_TP | 12 Jan 2016 | 1,823 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 01 | CO22 | MOTOR_TP | 14 Jan 2016 | 596 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 01 | CO22 | MOTOR_TP | 18 Jan 2016 | 1,524 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 01 | CO22 | MOTOR_TP | 19 Jan 2016 | 1,804 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 01 | CO22 | MOTOR_TP | 20 Jan 2016 | 1,777 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 01 | CO22 | MOTOR_TP | 21 Jan 2016 | 3,920 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 01 | CO22 | MOTOR_TP | 22 Jan 2016 | 3,328 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 01 | CO22 | MOTOR_TP | 25 Jan 2016 | 592 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 01 | CO22 | MOTOR_TP | 26 Jan 2016 | 592 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 01 | CO22 | MOTOR_TP | 27 Jan 2016 | 2,880 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 01 | CO22 | MOTOR_TP | 28 Jan 2016 | 592 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 02 | CO22 | MOTOR_TP | 01 Feb 2016 | 2,709 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 02 | CO22 | MOTOR_TP | 02 Feb 2016 | 1,524 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 02 | CO22 | MOTOR_TP | 05 Feb 2016 | 592 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 02 | CO22 | MOTOR_TP | 08 Feb 2016 | 592 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 02 | CO22 | MOTOR_TP | 09 Feb 2016 | 1,830 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 02 | CO22 | MOTOR_TP | 10 Feb 2016 | 2,396 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 02 | CO22 | MOTOR_TP | 11 Feb 2016 | 592 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 02 | CO22 | MOTOR_TP | 12 Feb 2016 | 1,524 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 02 | CO22 | MOTOR_TP | 13 Feb 2016 | 592 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 02 | CO22 | MOTOR_TP | 15 Feb 2016 | 1,211 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 02 | CO22 | MOTOR_TP | 16 Feb 2016 | 2,117 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 02 | CO22 | MOTOR_TP | 17 Feb 2016 | 619 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 02 | CO22 | MOTOR_TP | 18 Feb 2016 | 592 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 02 | CO22 | MOTOR_TP | 19 Feb 2016 | 2,704 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 02 | CO22 | MOTOR_TP | 20 Feb 2016 | 1,804 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 02 | CO22 | MOTOR_TP | 23 Feb 2016 | 592 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 02 | CO22 | MOTOR_TP | 24 Feb 2016 | 1,238 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 02 | CO22 | MOTOR_TP | 25 Feb 2016 | 2,112 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 02 | CO22 | MOTOR_TP | 26 Feb 2016 | 2,449 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 02 | CO22 | MOTOR_TP | 27 Feb 2016 | 1,185 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 02 | CO22 | MOTOR_TP | 29 Feb 2016 | 927 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 03 | CO22 | MOTOR_TP | 01 Mar 2016 | 1,185 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 03 | CO22 | MOTOR_TP | 02 Mar 2016 | 592 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 03 | CO22 | MOTOR_TP | 03 Mar 2016 | 1,211 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 03 | CO22 | MOTOR_TP | 04 Mar 2016 | 619 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 03 | CO22 | MOTOR_TP | 07 Mar 2016 | 592 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 03 | CO22 | MOTOR_TP | 08 Mar 2016 | 1,185 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 03 | CO22 | MOTOR_TP | 09 Mar 2016 | 1,695 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 03 | CO22 | MOTOR_TP | 10 Mar 2016 | 1,777 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 03 | CO22 | MOTOR_TP | 11 Mar 2016 | 1,519 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 03 | CO22 | MOTOR_TP | 17 Mar 2016 | 3,608 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 03 | CO22 | MOTOR_TP | 23 Mar 2016 | 592 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 03 | CO22 | MOTOR_TP | 24 Mar 2016 | 5,951 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 03 | CO22 | MOTOR_TP | 25 Mar 2016 | 619 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 03 | CO22 | MOTOR_TP | 28 Mar 2016 | 1,185 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 03 | CO22 | MOTOR_TP | 30 Mar 2016 | 2,396 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 03 | CO22 | MOTOR_TP | 31 Mar 2016 | 1,103 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 04 | CO22 | MOTOR_TP | 04 Apr 2016 | 592 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 04 | CO22 | MOTOR_TP | 05 Apr 2016 | 1,804 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 04 | CO22 | MOTOR_TP | 07 Apr 2016 | 619 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 04 | CO22 | MOTOR_TP | 11 Apr 2016 | 2,704 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 05 | CO22 | MOTOR_TP | 05 May 2016 | 629 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 05 | CO22 | MOTOR_TP | 06 May 2016 | 596 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 05 | CO22 | MOTOR_TP | 12 May 2016 | 650 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 05 | CO22 | MOTOR_TP | 13 May 2016 | 2,827 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 05 | CO22 | MOTOR_TP | 16 May 2016 | 629 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 05 | CO22 | MOTOR_TP | 17 May 2016 | 596 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 05 | CO22 | MOTOR_TP | 22 May 2016 | 596 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 05 | CO22 | MOTOR_TP | 25 May 2016 | 1,224 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 05 | CO22 | MOTOR_TP | 28 May 2016 | 596 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 06 | CO22 | MOTOR_TP | 03 Jun 2016 | 596 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 06 | CO22 | MOTOR_TP | 06 Jun 2016 | 2,382 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 06 | CO22 | MOTOR_TP | 07 Jun 2016 | 596 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 06 | CO22 | MOTOR_TP | 14 Jun 2016 | 2,575 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 06 | CO22 | MOTOR_TP | 15 Jun 2016 | 5,179 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 06 | CO22 | MOTOR_TP | 16 Jun 2016 | 596 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 06 | CO22 | MOTOR_TP | 23 Jun 2016 | 990 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 06 | CO22 | MOTOR_TP | 24 Jun 2016 | 1,191 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 06 | CO22 | MOTOR_TP | 29 Jun 2016 | 596 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 07 | CO22 | MOTOR_TP | 12 Jul 2016 | 3,680 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 07 | CO22 | MOTOR_TP | 14 Jul 2016 | 1,499 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 07 | CO22 | MOTOR_TP | 15 Jul 2016 | 1,191 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 07 | CO22 | MOTOR_TP | 20 Jul 2016 | 3,372 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 07 | CO22 | MOTOR_TP | 21 Jul 2016 | 2,382 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 07 | CO22 | MOTOR_TP | 22 Jul 2016 | 1,191 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 07 | CO22 | MOTOR_TP | 27 Jul 2016 | 1,787 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 07 | CO22 | MOTOR_TP | 28 Jul 2016 | 596 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 07 | CO22 | MOTOR_TP | 29 Jul 2016 | 596 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 08 | CO22 | MOTOR_TP | 05 Aug 2016 | 990 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 08 | CO22 | MOTOR_TP | 08 Aug 2016 | 1,787 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 08 | CO22 | MOTOR_TP | 09 Aug 2016 | 2,489 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 08 | CO22 | MOTOR_TP | 11 Aug 2016 | 596 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 08 | CO22 | MOTOR_TP | 12 Aug 2016 | 1,191 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 08 | CO22 | MOTOR_TP | 16 Aug 2016 | 1,191 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 08 | CO22 | MOTOR_TP | 18 Aug 2016 | 1,191 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 08 | CO22 | MOTOR_TP | 19 Aug 2016 | 1,191 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 08 | CO22 | MOTOR_TP | 22 Aug 2016 | 596 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 08 | CO22 | MOTOR_TP | 24 Aug 2016 | 619 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 08 | CO22 | MOTOR_TP | 26 Aug 2016 | 1,560 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 08 | CO22 | MOTOR_TP | 29 Aug 2016 | 3,212 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 08 | CO22 | MOTOR_TP | 30 Aug 2016 | 619 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 09 | CO22 | MOTOR_TP | 05 Sep 2016 | 619 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 09 | CO22 | MOTOR_TP | 06 Sep 2016 | 2,179 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 09 | CO22 | MOTOR_TP | 09 Sep 2016 | 2,593 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 09 | CO22 | MOTOR_TP | 14 Sep 2016 | 1,560 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 09 | CO22 | MOTOR_TP | 15 Sep 2016 | 619 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 09 | CO22 | MOTOR_TP | 20 Sep 2016 | 6,628 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 09 | CO22 | MOTOR_TP | 23 Sep 2016 | 1,238 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 09 | CO22 | MOTOR_TP | 26 Sep 2016 | 1,856 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 09 | CO22 | MOTOR_TP | 27 Sep 2016 | 1,238 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 10 | CO22 | MOTOR_TP | 05 Oct 2016 | 619 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 10 | CO22 | MOTOR_TP | 06 Oct 2016 | 619 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 10 | CO22 | MOTOR_TP | 07 Oct 2016 | 619 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 10 | CO22 | MOTOR_TP | 11 Oct 2016 | 1,238 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 10 | CO22 | MOTOR_TP | 13 Oct 2016 | 619 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 10 | CO22 | MOTOR_TP | 14 Oct 2016 | 4,449 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 10 | CO22 | MOTOR_TP | 18 Oct 2016 | 619 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 10 | CO22 | MOTOR_TP | 19 Oct 2016 | 1,238 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 10 | CO22 | MOTOR_TP | 20 Oct 2016 | 1,856 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 10 | CO22 | MOTOR_TP | 21 Oct 2016 | 619 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 10 | CO22 | MOTOR_TP | 24 Oct 2016 | 619 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 10 | CO22 | MOTOR_TP | 27 Oct 2016 | 1,856 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 10 | CO22 | MOTOR_TP | 31 Oct 2016 | 3,739 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 11 | CO22 | MOTOR_TP | 01 Nov 2016 | 1,499 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 11 | CO22 | MOTOR_TP | 03 Nov 2016 | 2,489 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 11 | CO22 | MOTOR_TP | 04 Nov 2016 | 4,189 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 11 | CO22 | MOTOR_TP | 07 Nov 2016 | 1,499 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 11 | CO22 | MOTOR_TP | 09 Nov 2016 | 630 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 11 | CO22 | MOTOR_TP | 11 Nov 2016 | 3,183 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 11 | CO22 | MOTOR_TP | 15 Nov 2016 | 1,704 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 11 | CO22 | MOTOR_TP | 16 Nov 2016 | 630 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 11 | CO22 | MOTOR_TP | 18 Nov 2016 | 630 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 11 | CO22 | MOTOR_TP | 21 Nov 2016 | 3,183 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 11 | CO22 | MOTOR_TP | 22 Nov 2016 | 630 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 11 | CO22 | MOTOR_TP | 23 Nov 2016 | 1,259 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 11 | CO22 | MOTOR_TP | 25 Nov 2016 | 3,628 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 11 | CO22 | MOTOR_TP | 30 Nov 2016 | 1,259 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 12 | CO22 | MOTOR_TP | 01 Dec 2016 | 630 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 12 | CO22 | MOTOR_TP | 02 Dec 2016 | 630 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 12 | CO22 | MOTOR_TP | 05 Dec 2016 | 1,889 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 12 | CO22 | MOTOR_TP | 06 Dec 2016 | 630 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 12 | CO22 | MOTOR_TP | 07 Dec 2016 | 630 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 12 | CO22 | MOTOR_TP | 09 Dec 2016 | 630 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 12 | CO22 | MOTOR_TP | 14 Dec 2016 | 1,704 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 12 | CO22 | MOTOR_TP | 15 Dec 2016 | 630 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 12 | CO22 | MOTOR_TP | 19 Dec 2016 | 5,756 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 12 | CO22 | MOTOR_TP | 20 Dec 2016 | 1,499 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 12 | CO22 | MOTOR_TP | 21 Dec 2016 | 2,553 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 12 | CO22 | MOTOR_TP | 27 Dec 2016 | 3,183 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 12 | CO22 | MOTOR_TP | 29 Dec 2016 | 3,402 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 12 | CO22 | MOTOR_TP | 30 Dec 2016 | 1,704 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | 12 | CO22 | MOTOR_TP | 31 Dec 2016 | 630 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2016 | Total | 230,062 | ||||
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 01 | CO22 | MOTOR_TP | 03 Jan 2017 | 630 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 01 | CO22 | MOTOR_TP | 04 Jan 2017 | 630 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 01 | CO22 | MOTOR_TP | 05 Jan 2017 | 630 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 01 | CO22 | MOTOR_TP | 06 Jan 2017 | 2,518 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 01 | CO22 | MOTOR_TP | 11 Jan 2017 | 2,998 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 01 | CO22 | MOTOR_TP | 12 Jan 2017 | 1,924 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 01 | CO22 | MOTOR_TP | 16 Jan 2017 | 9,329 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 01 | CO22 | MOTOR_TP | 18 Jan 2017 | 2,779 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 01 | CO22 | MOTOR_TP | 20 Jan 2017 | 630 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 01 | CO22 | MOTOR_TP | 21 Jan 2017 | 630 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 01 | CO22 | MOTOR_TP | 23 Jan 2017 | 3,203 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 01 | CO22 | MOTOR_TP | 24 Jan 2017 | 630 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 01 | CO22 | MOTOR_TP | 25 Jan 2017 | 630 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 01 | CO22 | MOTOR_TP | 26 Jan 2017 | 2,129 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 01 | CO22 | MOTOR_TP | 27 Jan 2017 | 1,924 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 01 | CO22 | MOTOR_TP | 30 Jan 2017 | 3,183 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 02 | CO22 | MOTOR_TP | 01 Feb 2017 | 1,924 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 02 | CO22 | MOTOR_TP | 02 Feb 2017 | 3,183 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 02 | CO22 | MOTOR_TP | 03 Feb 2017 | 1,259 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 02 | CO22 | MOTOR_TP | 06 Feb 2017 | 1,889 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 02 | CO22 | MOTOR_TP | 07 Feb 2017 | 1,704 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 02 | CO22 | MOTOR_TP | 08 Feb 2017 | 1,889 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 02 | CO22 | MOTOR_TP | 09 Feb 2017 | 1,259 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 02 | CO22 | MOTOR_TP | 13 Feb 2017 | 4,052 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 02 | CO22 | MOTOR_TP | 14 Feb 2017 | 1,704 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 02 | CO22 | MOTOR_TP | 16 Feb 2017 | 1,889 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 02 | CO22 | MOTOR_TP | 20 Feb 2017 | 1,259 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 02 | CO22 | MOTOR_TP | 21 Feb 2017 | 1,889 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 02 | CO22 | MOTOR_TP | 22 Feb 2017 | 1,259 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 02 | CO22 | MOTOR_TP | 23 Feb 2017 | 3,847 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 02 | CO22 | MOTOR_TP | 24 Feb 2017 | 630 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 02 | CO22 | MOTOR_TP | 25 Feb 2017 | 630 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 02 | CO22 | MOTOR_TP | 27 Feb 2017 | 1,889 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 02 | CO22 | MOTOR_TP | 28 Feb 2017 | 630 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 03 | CO22 | MOTOR_TP | 01 Mar 2017 | 630 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 03 | CO22 | MOTOR_TP | 02 Mar 2017 | 630 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 03 | CO22 | MOTOR_TP | 03 Mar 2017 | 7,030 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 03 | CO22 | MOTOR_TP | 06 Mar 2017 | 3,388 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 03 | CO22 | MOTOR_TP | 07 Mar 2017 | 630 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 03 | CO22 | MOTOR_TP | 08 Mar 2017 | 4,017 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 03 | CO22 | MOTOR_TP | 09 Mar 2017 | 1,259 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 03 | CO22 | MOTOR_TP | 10 Mar 2017 | 5,516 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 03 | CO22 | MOTOR_TP | 14 Mar 2017 | 3,408 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 03 | CO22 | MOTOR_TP | 15 Mar 2017 | 2,758 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 03 | CO22 | MOTOR_TP | 20 Mar 2017 | 630 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 03 | CO22 | MOTOR_TP | 21 Mar 2017 | 3,148 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 03 | CO22 | MOTOR_TP | 22 Mar 2017 | 1,704 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 03 | CO22 | MOTOR_TP | 23 Mar 2017 | 630 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 03 | CO22 | MOTOR_TP | 24 Mar 2017 | 1,889 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 03 | CO22 | MOTOR_TP | 27 Mar 2017 | 630 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 03 | CO22 | MOTOR_TP | 28 Mar 2017 | 2,518 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 03 | CO22 | MOTOR_TP | 29 Mar 2017 | 1,259 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 03 | CO22 | MOTOR_TP | 30 Mar 2017 | 630 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 03 | CO22 | MOTOR_TP | 31 Mar 2017 | 5,926 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 04 | CO22 | MOTOR_TP | 03 Apr 2017 | 6,401 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 04 | CO22 | MOTOR_TP | 05 Apr 2017 | 2,773 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 04 | CO22 | MOTOR_TP | 06 Apr 2017 | 1,889 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 04 | CO22 | MOTOR_TP | 07 Apr 2017 | 1,075 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 04 | CO22 | MOTOR_TP | 11 Apr 2017 | 7,850 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 04 | CO22 | MOTOR_TP | 21 Apr 2017 | 6,775 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 04 | CO22 | MOTOR_TP | 24 Apr 2017 | 630 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 04 | CO22 | MOTOR_TP | 25 Apr 2017 | 3,183 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 04 | CO22 | MOTOR_TP | 26 Apr 2017 | 1,259 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 04 | CO22 | MOTOR_TP | 27 Apr 2017 | 1,075 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 04 | CO22 | MOTOR_TP | 28 Apr 2017 | 630 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 05 | CO22 | MOTOR_TP | 02 May 2017 | 1,889 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 05 | CO22 | MOTOR_TP | 03 May 2017 | 1,075 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 05 | CO22 | MOTOR_TP | 05 May 2017 | 2,553 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 05 | CO22 | MOTOR_TP | 08 May 2017 | 1,259 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 05 | CO22 | MOTOR_TP | 09 May 2017 | 630 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 05 | CO22 | MOTOR_TP | 15 May 2017 | 1,259 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 05 | CO22 | MOTOR_TP | 16 May 2017 | 1,259 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 05 | CO22 | MOTOR_TP | 17 May 2017 | 2,334 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 05 | CO22 | MOTOR_TP | 18 May 2017 | 1,259 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 05 | CO22 | MOTOR_TP | 19 May 2017 | 630 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 05 | CO22 | MOTOR_TP | 23 May 2017 | 2,553 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 05 | CO22 | MOTOR_TP | 24 May 2017 | 1,924 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 05 | CO22 | MOTOR_TP | 25 May 2017 | 630 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 05 | CO22 | MOTOR_TP | 26 May 2017 | 630 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 05 | CO22 | MOTOR_TP | 30 May 2017 | 2,553 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 05 | CO22 | MOTOR_TP | 31 May 2017 | 630 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 06 | CO22 | MOTOR_TP | 01 Jun 2017 | 1,499 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 06 | CO22 | MOTOR_TP | 02 Jun 2017 | 1,704 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 06 | CO22 | MOTOR_TP | 05 Jun 2017 | 3,812 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 06 | CO22 | MOTOR_TP | 07 Jun 2017 | 1,889 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 06 | CO22 | MOTOR_TP | 12 Jun 2017 | 1,075 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 06 | CO22 | MOTOR_TP | 13 Jun 2017 | 1,924 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 06 | CO22 | MOTOR_TP | 14 Jun 2017 | 2,963 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 06 | CO22 | MOTOR_TP | 15 Jun 2017 | 630 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | 06 | CO22 | MOTOR_TP | 16 Jun 2017 | 1,889 | |
SC019 | Piriwena Juntion | 10-Nov-2014 | 2017 | Total | 189,387 | ||||
SC019 | Piriwena Juntion | 10-Nov-2014 | Total | 633,199 |
Hi,
Please send this in excel. Also i can not find the marketing date which you used in your expression.
Regards,
Kaushik Solanki
SCCOD | Opening_Date | MARKETING_DATE | POLICY_NO | Data |
SC019 | 10-Nov-2014 | 01 Jun 2015 | CO22153F0026512 | 522 |
SC019 | 10-Nov-2014 | 01 Jun 2015 | CO22153W0002670 | 856 |
SC019 | 10-Nov-2014 | 01 Jun 2015 | 0 | |
SC019 | 10-Nov-2014 | 03 Jun 2015 | CO22151F0006835 | -11,504 |
SC019 | 10-Nov-2014 | 04 Jun 2015 | CO22153C0001588 | 549 |
SC019 | 10-Nov-2014 | 04 Jun 2015 | CO22153F0026601 | 522 |
SC019 | 10-Nov-2014 | 04 Jun 2015 | CO22153F0026608 | 522 |
SC019 | 10-Nov-2014 | 05 Jun 2015 | CO22153A0003952 | 549 |
SC019 | 10-Nov-2014 | 08 Jun 2015 | CO22153F0026777 | 522 |
SC019 | 10-Nov-2014 | 09 Jun 2015 | CO22151A0011272 | -6,000 |
SC019 | 10-Nov-2014 | 09 Jun 2015 | CO22153A0003979 | 549 |
SC019 | 10-Nov-2014 | 09 Jun 2015 | CO22151A0011620 | 60,649 |
SC019 | 10-Nov-2014 | 10 Jun 2015 | CO22154X0001953 | 1,658 |
SC019 | 10-Nov-2014 | 10 Jun 2015 | CO22154X0001954 | 2,758 |
SC019 | 10-Nov-2014 | 10 Jun 2015 | CO22154X0001955 | 2,538 |
SC019 | 10-Nov-2014 | 10 Jun 2015 | CO22154X0001952 | 3,858 |
SC019 | 10-Nov-2014 | 10 Jun 2015 | CO22154X0001956 | 2,758 |
SC019 | 10-Nov-2014 | 10 Jun 2015 | CO22154X0001943 | 1,658 |
SC019 | 10-Nov-2014 | 10 Jun 2015 | CO22154X0001944 | 1,548 |
SC019 | 10-Nov-2014 | 10 Jun 2015 | CO22154X0001946 | 3,858 |
SC019 | 10-Nov-2014 | 10 Jun 2015 | CO22154X0001949 | 3,638 |
SC019 | 10-Nov-2014 | 10 Jun 2015 | CO22154X0001960 | 2,483 |
SC019 | 10-Nov-2014 | 10 Jun 2015 | CO22154X0001961 | 2,538 |
SC019 | 10-Nov-2014 | 10 Jun 2015 | CO22154X0001947 | 2,648 |
SC019 | 10-Nov-2014 | 10 Jun 2015 | CO22154X0001948 | 2,208 |
SC019 | 10-Nov-2014 | 10 Jun 2015 | CO22154X0001945 | 3,308 |
SC019 | 10-Nov-2014 | 10 Jun 2015 | CO22154X0001950 | 2,208 |
SC019 | 10-Nov-2014 | 10 Jun 2015 | CO22154X0001959 | 2,208 |
SC019 | 10-Nov-2014 | 10 Jun 2015 | CO22154X0001957 | 4,078 |
SC019 | 10-Nov-2014 | 10 Jun 2015 | CO22154X0001958 | 2,208 |
SC019 | 10-Nov-2014 | 10 Jun 2015 | CO22154X0001951 | 3,088 |
SC019 | 10-Nov-2014 | 11 Jun 2015 | CO22154X0001964 | 1,768 |
SC019 | 10-Nov-2014 | 11 Jun 2015 | CO22154X0001962 | 1,988 |
SC019 | 10-Nov-2014 | 11 Jun 2015 | CO22154X0001963 | 2,648 |
SC019 | 10-Nov-2014 | 11 Jun 2015 | CO22151A0010376 | 6,285 |
SC019 | 10-Nov-2014 | 11 Jun 2015 | CO22154X0001968 | 1,988 |
SC019 | 10-Nov-2014 | 11 Jun 2015 | CO22154X0001967 | 3,418 |
SC019 | 10-Nov-2014 | 11 Jun 2015 | CO22153F0026992 | 522 |
SC019 | 10-Nov-2014 | 11 Jun 2015 | CO22153A0004000 | 549 |
SC019 | 10-Nov-2014 | 11 Jun 2015 | CO22154X0001965 | 2,428 |
SC019 | 10-Nov-2014 | 11 Jun 2015 | CO22154X0001966 | 2,098 |
SC019 | 10-Nov-2014 | 12 Jun 2015 | CO22154X0001974 | 2,868 |
SC019 | 10-Nov-2014 | 12 Jun 2015 | CO22154X0001984 | 1,658 |
SC019 | 10-Nov-2014 | 12 Jun 2015 | CO22154X0001981 | 2,208 |
SC019 | 10-Nov-2014 | 12 Jun 2015 | CO22154X0001975 | 1,548 |
SC019 | 10-Nov-2014 | 12 Jun 2015 | CO22154X0001977 | 2,098 |
SC019 | 10-Nov-2014 | 12 Jun 2015 | CO22154X0001985 | 1,438 |
SC019 | 10-Nov-2014 | 12 Jun 2015 | CO22154X0001971 | 1,548 |
SC019 | 10-Nov-2014 | 12 Jun 2015 | CO22154X0001986 | 2,208 |
SC019 | 10-Nov-2014 | 12 Jun 2015 | CO22151A0010250 | -54,326 |
SC019 | 10-Nov-2014 | 12 Jun 2015 | CO22154X0001972 | 2,758 |
SC019 | 10-Nov-2014 | 12 Jun 2015 | CO22154X0001978 | 2,648 |
SC019 | 10-Nov-2014 | 12 Jun 2015 | CO22154X0001982 | 2,208 |
SC019 | 10-Nov-2014 | 12 Jun 2015 | CO22154X0001980 | 4,408 |
SC019 | 10-Nov-2014 | 12 Jun 2015 | CO22154X0001976 | 2,538 |
SC019 | 10-Nov-2014 | 12 Jun 2015 | CO22154X0001983 | 2,318 |
SC019 | 10-Nov-2014 | 12 Jun 2015 | CO22154X0001979 | 2,538 |
SC019 | 10-Nov-2014 | 16 Jun 2015 | CO22153F0027241 | 522 |
SC019 | 10-Nov-2014 | 17 Jun 2015 | CO22153F0027277 | 522 |
SC019 | 10-Nov-2014 | 18 Jun 2015 | CO22151A0011746 | 46,366 |
SC019 | 10-Nov-2014 | 19 Jun 2015 | CO22153A0004049 | 549 |
SC019 | 10-Nov-2014 | 19 Jun 2015 | CO22153A0004055 | 549 |
SC019 | 10-Nov-2014 | 20 Jun 2015 | CO22154X0002010 | 1,658 |
SC019 | 10-Nov-2014 | 20 Jun 2015 | CO22153C0001648 | 549 |
SC019 | 10-Nov-2014 | 20 Jun 2015 | CO22154X0002014 | 4,188 |
SC019 | 10-Nov-2014 | 20 Jun 2015 | CO22154X0002020 | 1,658 |
SC019 | 10-Nov-2014 | 22 Jun 2015 | CO22153A0004073 | 549 |
SC019 | 10-Nov-2014 | 22 Jun 2015 | CO22154X0002028 | 2,208 |
SC019 | 10-Nov-2014 | 23 Jun 2015 | CO22153F0027613 | 522 |
SC019 | 10-Nov-2014 | 23 Jun 2015 | CO22153F0027624 | 522 |
SC019 | 10-Nov-2014 | 23 Jun 2015 | CO22153F0027566 | 522 |
SC019 | 10-Nov-2014 | 24 Jun 2015 | CO22151A0010376 | -9,912 |
SC019 | 10-Nov-2014 | 25 Jun 2015 | CO22151A0011870 | 54,326 |
SC019 | 10-Nov-2014 | 25 Jun 2015 | CO22153W0002928 | 856 |
SC019 | 10-Nov-2014 | 25 Jun 2015 | CO22151A0011878 | 125,441 |
SC019 | 10-Nov-2014 | 25 Jun 2015 | CO22151A0011879 | 75,221 |
SC019 | 10-Nov-2014 | 26 Jun 2015 | CO22153W0002963 | 856 |
SC019 | 10-Nov-2014 | 26 Jun 2015 | CO22153F0027836 | 522 |
SC019 | 10-Nov-2014 | 26 Jun 2015 | CO22151W0000462 | 9,125 |
SC019 | 10-Nov-2014 | 26 Jun 2015 | CO22153F0027832 | 522 |
SC019 | 10-Nov-2014 | 27 Jun 2015 | CO22154X0002058 | 3,528 |
SC019 | 10-Nov-2014 | 29 Jun 2015 | CO22153A0004122 | 549 |
SC019 | 10-Nov-2014 | 29 Jun 2015 | CO22153A0004123 | 549 |
SC019 | 10-Nov-2014 | 29 Jun 2015 | CO22153F0027903 | 522 |
SC019 | 10-Nov-2014 | 29 Jun 2015 | CO22153F0027901 | 522 |
SC019 | 10-Nov-2014 | 29 Jun 2015 | CO22153A0004129 | 549 |
SC019 | 10-Nov-2014 | 30 Jun 2015 | CO22153F0028072 | 522 |
SC019 | 10-Nov-2014 | 30 Jun 2015 | CO22154X0002097 | 2,538 |
SC019 | 10-Nov-2014 | 30 Jun 2015 | CO22153F0028071 | 522 |
SC019 | 10-Nov-2014 | 30 Jun 2015 | CO22154X0002093 | 1,988 |
SC019 | 10-Nov-2014 | 30 Jun 2015 | CO22154X0002094 | 1,328 |
SC019 | 10-Nov-2014 | 30 Jun 2015 | CO22151A0011980 | 54,055 |
SC019 | 10-Nov-2014 | 30 Jun 2015 | CO22153F0028046 | 522 |
SC019 | 10-Nov-2014 | 30 Jun 2015 | CO22151A0011926 | 110,390 |
SC019 | 10-Nov-2014 | 30 Jun 2015 | CO22154X0002096 | 2,208 |
SC019 | 10-Nov-2014 | 01 Jun 2016 | CO22154X0001974 | 4,486 |
SC019 | 10-Nov-2014 | 01 Jun 2016 | CO22154X0001963 | 4,180 |
SC019 | 10-Nov-2014 | 01 Jun 2016 | CO22154X0001971 | 2,650 |
SC019 | 10-Nov-2014 | 01 Jun 2016 | CO22154X0001972 | 4,333 |
SC019 | 10-Nov-2014 | 01 Jun 2016 | CO22154X0001979 | 4,027 |
SC019 | 10-Nov-2014 | 01 Jun 2016 | 0 | |
SC019 | 10-Nov-2014 | 02 Jun 2016 | CO22154X0001980 | 6,628 |
SC019 | 10-Nov-2014 | 03 Jun 2016 | CO22154X0001953 | 2,803 |
SC019 | 10-Nov-2014 | 03 Jun 2016 | CO22154X0001975 | 2,650 |
SC019 | 10-Nov-2014 | 03 Jun 2016 | CO22154X0001943 | 2,803 |
SC019 | 10-Nov-2014 | 03 Jun 2016 | CO22154X0001978 | 4,180 |
SC019 | 10-Nov-2014 | 03 Jun 2016 | CO22163F0061141 | 596 |
SC019 | 10-Nov-2014 | 04 Jun 2016 | CO22154X0001952 | 5,863 |
SC019 | 10-Nov-2014 | 04 Jun 2016 | CO22154X0001967 | 5,251 |
SC019 | 10-Nov-2014 | 04 Jun 2016 | CO22154X0001983 | 3,721 |
SC019 | 10-Nov-2014 | 04 Jun 2016 | CO22154X0002020 | 2,803 |
SC019 | 10-Nov-2014 | 05 Jun 2016 | CO22154X0001981 | 3,568 |
SC019 | 10-Nov-2014 | 06 Jun 2016 | CO22163F0061369 | 596 |
SC019 | 10-Nov-2014 | 06 Jun 2016 | CO22163F0061356 | 596 |
SC019 | 10-Nov-2014 | 06 Jun 2016 | CO22163F0061424 | 596 |
SC019 | 10-Nov-2014 | 06 Jun 2016 | CO22163F0061421 | 596 |
SC019 | 10-Nov-2014 | 07 Jun 2016 | CO22163F0061588 | 596 |
SC019 | 10-Nov-2014 | 08 Jun 2016 | CO22154X0001985 | 2,497 |
SC019 | 10-Nov-2014 | 08 Jun 2016 | CO22154X0001982 | 3,568 |
SC019 | 10-Nov-2014 | 09 Jun 2016 | CO22154X0001981 | -3,568 |
SC019 | 10-Nov-2014 | 09 Jun 2016 | CO22154X0001961 | 4,027 |
SC019 | 10-Nov-2014 | 10 Jun 2016 | CO22154X0002014 | 6,322 |
SC019 | 10-Nov-2014 | 10 Jun 2016 | CO22154X0001948 | 3,568 |
SC019 | 10-Nov-2014 | 12 Jun 2016 | CO22154X0002010 | 2,803 |
SC019 | 10-Nov-2014 | 12 Jun 2016 | CO22161A0016003 | -68,380 |
SC019 | 10-Nov-2014 | 14 Jun 2016 | CO22153F0026992 | 596 |
SC019 | 10-Nov-2014 | 14 Jun 2016 | CO22163W0011601 | 990 |
SC019 | 10-Nov-2014 | 14 Jun 2016 | CO22163W0011599 | 990 |
SC019 | 10-Nov-2014 | 15 Jun 2016 | CO22163A0007979 | 1,499 |
SC019 | 10-Nov-2014 | 15 Jun 2016 | CO22163W0011629 | 990 |
SC019 | 10-Nov-2014 | 15 Jun 2016 | CO22163A0007982 | 1,499 |
SC019 | 10-Nov-2014 | 15 Jun 2016 | CO22163F0062606 | 596 |
SC019 | 10-Nov-2014 | 15 Jun 2016 | CO22163F0062602 | 596 |
SC019 | 10-Nov-2014 | 16 Jun 2016 | CO22163F0062767 | 596 |
SC019 | 10-Nov-2014 | 18 Jun 2016 | CO22151A0011746 | 47,166 |
SC019 | 10-Nov-2014 | 20 Jun 2016 | CO22161A0017071 | -29,330 |
SC019 | 10-Nov-2014 | 23 Jun 2016 | CO22163W0011888 | 990 |
SC019 | 10-Nov-2014 | 24 Jun 2016 | CO22154X0002094 | 2,344 |
SC019 | 10-Nov-2014 | 24 Jun 2016 | CO22163F0063756 | 596 |
SC019 | 10-Nov-2014 | 24 Jun 2016 | CO22163F0063762 | 596 |
SC019 | 10-Nov-2014 | 25 Jun 2016 | CO22151A0011878 | 97,468 |
SC019 | 10-Nov-2014 | 25 Jun 2016 | CO22154X0002096 | 3,568 |
SC019 | 10-Nov-2014 | 26 Jun 2016 | CO22154X0002097 | 4,027 |
SC019 | 10-Nov-2014 | 29 Jun 2016 | CO22153F0027901 | 596 |
SC019 | 10-Nov-2014 | 29 Jun 2016 | CO22161A0018060 | 116,219 |
SC019 | 10-Nov-2014 | 30 Jun 2016 | CO22161A0016562 | -49,880 |
SC019 | 10-Nov-2014 | 01 Jun 2017 | CO22153C0001532 | 1,499 |
SC019 | 10-Nov-2014 | 01 Jun 2017 | CO22171A0022190 | -49,555 |
SC019 | 10-Nov-2014 | 01 Jun 2017 | CO22171A0021205 | -14,207 |
SC019 | 10-Nov-2014 | 01 Jun 2017 | 0 | |
SC019 | 10-Nov-2014 | 02 Jun 2017 | CO22173F0111333 | 630 |
SC019 | 10-Nov-2014 | 02 Jun 2017 | CO22173W0021273 | 1,075 |
SC019 | 10-Nov-2014 | 05 Jun 2017 | CO22171A0022431 | -23,280 |
SC019 | 10-Nov-2014 | 05 Jun 2017 | CO22173F0111494 | 630 |
SC019 | 10-Nov-2014 | 05 Jun 2017 | CO22173F0111600 | 630 |
SC019 | 10-Nov-2014 | 05 Jun 2017 | CO22173F0111515 | 630 |
SC019 | 10-Nov-2014 | 05 Jun 2017 | CO22173A0010663 | 1,924 |
SC019 | 10-Nov-2014 | 07 Jun 2017 | CO22173F0111819 | 630 |
SC019 | 10-Nov-2014 | 07 Jun 2017 | CO22173F0111936 | 630 |
SC019 | 10-Nov-2014 | 07 Jun 2017 | CO22173F0111802 | 630 |
SC019 | 10-Nov-2014 | 12 Jun 2017 | CO22173W0021476 | 1,075 |
SC019 | 10-Nov-2014 | 13 Jun 2017 | CO22173A0010712 | 1,924 |
SC019 | 10-Nov-2014 | 14 Jun 2017 | CO22173F0112750 | 630 |
SC019 | 10-Nov-2014 | 14 Jun 2017 | CO22173W0021548 | 1,075 |
SC019 | 10-Nov-2014 | 14 Jun 2017 | CO22173F0112751 | 630 |
SC019 | 10-Nov-2014 | 14 Jun 2017 | CO22173F0112752 | 630 |
SC019 | 10-Nov-2014 | 15 Jun 2017 | CO22173F0112796 | 630 |
SC019 | 10-Nov-2014 | 16 Jun 2017 | CO22173F0112866 | 630 |
SC019 | 10-Nov-2014 | 16 Jun 2017 | CO22173F0112863 | 630 |
SC019 | 10-Nov-2014 | 16 Jun 2017 | CO22173F0112859 | 630 |
SC019 | 10-Nov-2014 | 19 Jun 2017 | CO22151A0011746 | 45,100 |
SC019 | 10-Nov-2014 | 19 Jun 2017 | CO22173F0113094 | 630 |
SC019 | 10-Nov-2014 | 20 Jun 2017 | CO22171C0007308 | 23,080 |
SC019 | 10-Nov-2014 | 20 Jun 2017 | CO22173F0113280 | 630 |
SC019 | 10-Nov-2014 | 21 Jun 2017 | CO22173F0113574 | 630 |
SC019 | 10-Nov-2014 | 21 Jun 2017 | CO22173F0113598 | 630 |
SC019 | 10-Nov-2014 | 22 Jun 2017 | CO22173F0113706 | 630 |
SC019 | 10-Nov-2014 | 23 Jun 2017 | CO22171A0023604 | 40,430 |
SC019 | 10-Nov-2014 | 25 Jun 2017 | CO22151A0011878 | 91,775 |
SC019 | 10-Nov-2014 | 27 Jun 2017 | CO22173F0114169 | 630 |
SC019 | 10-Nov-2014 | 28 Jun 2017 | CO22161A0018060 | 80,321 |
SC019 | 10-Nov-2014 | 28 Jun 2017 | CO22173F0114274 | 630 |
SC019 | 10-Nov-2014 | 28 Jun 2017 | CO22171A0023693 | 68,815 |
SC019 | 10-Nov-2014 | 29 Jun 2017 | CO22173C0004022 | 1,499 |
Hi Sagara,
On what basis you require 6 against Year 17. as per calculation, it shows 32.
Formula is:=(max(MARKETING_DATE) - (Opening_Date))/30
M3 | M3 | M3 | ||||
SCCOD | SCNAME | Opening_Date | YEAR | sales | No_Of_Month | Avg_Sales |
01 | P | 10-Nov-2014 | 2014 | 26,669 | 2 | 16,328 |
10-Nov-2014 | 2015 | 187,080 | 12 | 15,590 | ||
10-Nov-2014 | 2016 | 230,062 | 12 | 19,172 | ||
10-Nov-2014 | 2017 | 189,387 | 6 | 31,565 | ||
10-Nov-2014 | Total | 633,199 | 32 | 20,017 |
Thanks,
Arvind Patil