dates calcultion

[#1]

hi experts,

i have two tables like below i want last 3 days(without holidays) and 5 days(without holidays) as a separate buckets.when ever i click 3 days bucket or 5 days bucket it has to display last 3 days sales or 5 days sales in bar chart.

in billing day 1-working day 0-holiday,

can you please help me...

Date	Sales	Country
1-Apr-15	4566.24	Germany
2-Apr-15	4122.30	Germany
3-Apr-15	4185.72	Germany
4-Apr-15	5073.60	Germany
5-Apr-15	951.30	Germany
6-Apr-15	4566.24	Germany
7-Apr-15	4724.79	Germany
8-Apr-15	3963.75	Germany
9-Apr-15	4230.11	Germany
10-Apr-15	4299.88	Germany
11-Apr-15	5073.60	Germany
12-Apr-15	317.10	Germany
13-Apr-15	3963.75	Germany
14-Apr-15	3963.75	Germany
15-Apr-15	4724.79	Germany
16-Apr-15	3963.75	Germany
17-Apr-15	4230.11	Germany
18-Apr-15	1458.66	Germany
19-Apr-15	1204.98	Germany
20-Apr-15	4724.79	Germany
21-Apr-15	3963.75	Germany
22-Apr-15	4230.11	Germany
23-Apr-15	4724.79	Germany
24-Apr-15	3963.75	Germany
25-Apr-15	1426.95	Germany
26-Apr-15	780.07	Germany
27-Apr-15	4724.79	Germany
1-Apr-15	5288.40	UK
2-Apr-15	4774.25	UK
3-Apr-15	4847.70	UK
4-Apr-15	5876.00	UK
5-Apr-15	1101.75	UK
6-Apr-15	5288.40	UK
7-Apr-15	5472.03	UK
8-Apr-15	4590.63	UK
9-Apr-15	4899.12	UK
10-Apr-15	4979.91	UK
11-Apr-15	5876.00	UK
12-Apr-15	367.25	UK
13-Apr-15	4590.63	UK
14-Apr-15	4590.63	UK
15-Apr-15	5472.03	UK
16-Apr-15	4590.63	UK
17-Apr-15	4899.12	UK
18-Apr-15	1689.35	UK
19-Apr-15	1395.55	UK
20-Apr-15	5472.03	UK
21-Apr-15	4590.63	UK
22-Apr-15	4899.12	UK
23-Apr-15	5472.03	UK
24-Apr-15	4590.63	UK
25-Apr-15	1652.63	UK
26-Apr-15	903.44	UK
27-Apr-15	5472.03	UK

2nd table

Date	Billing Day	Country
1-Apr-15	1	Germany
2-Apr-15	1	Germany
3-Apr-15	1	Germany
4-Apr-15	0	Germany
5-Apr-15	0	Germany
6-Apr-15	0	Germany
7-Apr-15	1	Germany
8-Apr-15	1	Germany
9-Apr-15	1	Germany
10-Apr-15	1	Germany
11-Apr-15	0	Germany
12-Apr-15	0	Germany
13-Apr-15	1	Germany
14-Apr-15	1	Germany
15-Apr-15	1	Germany
16-Apr-15	1	Germany
17-Apr-15	1	Germany
18-Apr-15	0	Germany
19-Apr-15	0	Germany
20-Apr-15	1	Germany
21-Apr-15	1	Germany
22-Apr-15	1	Germany
23-Apr-15	1	Germany
24-Apr-15	1	Germany
25-Apr-15	0	Germany
26-Apr-15	0	Germany
27-Apr-15	1	Germany
28-Apr-15	1	Germany
29-Apr-15	1	Germany
30-Apr-15	1	Germany
1-Apr-15	1	UK
2-Apr-15	1	UK
3-Apr-15	1	UK
4-Apr-15	0	UK
5-Apr-15	0	UK
6-Apr-15	1	UK
7-Apr-15	1	UK
8-Apr-15	1	UK
9-Apr-15	1	UK
10-Apr-15	0	UK
11-Apr-15	0	UK
12-Apr-15	0	UK
13-Apr-15	1	UK
14-Apr-15	1	UK
15-Apr-15	1	UK
16-Apr-15	0	UK
17-Apr-15	1	UK
18-Apr-15	0	UK
19-Apr-15	0	UK
20-Apr-15	1	UK
21-Apr-15	1	UK
22-Apr-15	1	UK
23-Apr-15	1	UK
24-Apr-15	1	UK
25-Apr-15	0	UK
26-Apr-15	0	UK
27-Apr-15	1	UK
28-Apr-15	1	UK
29-Apr-15	1	UK
30-Apr-15	1	UK

[MarcoWedel]

please post your expected result.

thanks

regards

Marco

[MayilVahanan]

Hi

PFA

Did the script step by step for understanding purpose.

[amit_saini]

Hi Siva,

Check:

Find Net Working Days

Thanks,
AS

[#5]

in list box

bucket3

bucket5

when ever click in the bucket need to  show last 3days sales in bar charts