Backdate search

[santhosh_k_n]

Hi All,

I am having data as follows,

DIm1	Dim2	Product	Date	Measure2	Measure3	Measure4	Measure5	Measure6
D1	C1	p1	01/11/14	100	35	30	25	110
D1	C1	p2	01/11/14	150	25	30	25	150
D1	C1	p1	01/12/14	110	25	0	0	135
D1	C1	p1	01/13/14	135	100	30	90	145
D1	C1	p1	01/17/14	145	50	24	65	130
D1	C1	p1	01/18/14	130	0	10	0	130
D1	C1	p1	01/19/14	130	32	4	45	117
D1	C1	p3	01/19/14	150	32	4	45	137
D1	C1	p1	01/20/14	117	150	0	50	217
D1	C1	p3	01/20/14	137	0	0	30	107
D1	C1	p1	01/21/14	217	200	43	55	362
D1	C1	p1	01/29/14	362	0	10	100	262
D1	C1	p1	01/30/14	262	90	80	45	307
D1	C1	p1	01/31/14	307	50	60	44	313
D1	C1	p1	02/01/14	313	40	0	67	286
D1	C1	p1	02/02/14	286	30	0	23	293

in the above data I am apply date filter on a default calender filter which has a link with Date.

My results for different from and to date selections should be as follows,

1. From date 01/01/2014 to 30/01/2014
DIm1	Dim2	Product	Measere2	Measure3	Measure4	Measure5	Measure6
2. From date 11/01/2014 to 30/01/2014
DIm1	Dim2	Product	Measere2	Measure3	Measure4	Measure5	Measure6
D1	C1	p1	100	682	231	475	307
D1	C1	p2	150	25	30	25	150
3. from date: 15/Nov/2014 to 25/Nov/2014
DIm1	Dim2	Product	Measere2	Measure3	Measure4	Measure5	Measure6
D1	C1	p1	145	432	81	215	362
D1	C1	p2	150	25	30	25	150
4. from date: 21/Nov/2014 to 25/Nov/2014
DIm1	Dim2	Product	Measere2	Measure3	Measure4	Measure5	Measure6
D1	C1	p1	217	200	43	55	362
D1	C1	p2	150	25	30	25	150
D1	C1	p3	107	0	0	0	107

Hear measuer2 data should be equal to the Measure2 data if available on From data, Else measure2 is equal to Measure6 for previous transaction date less than From date.

Please guide me.

[amit_saini]

Hi,

You can create a two variables Say

vStart: =DATE(num(today())-1 + num('06:00:00'),'DD.MM.YYYY hh:mm:ss')

vEnd:=DATE(num(today()) + num('05:59:59'),'DD.MM.YYYY hh:mm:ss')

and assign these two variables to button , similarly you can create different buttons for  you date filters.

Wish you a very happy new year

Thanks,

AS

[santhosh_k_n]

Thanks Amit and wish you a happy new year too,

The date selections are not static so that It can be assigned to any variable and get handled.