How to get the last three values in the date column

[#1]

hi experts,

can any one help me on this.

I have table with filed names Date,Sales and country,i want to display last 3 dates as one bucket and 5 date values as one bucket,that two buckets will work like a fields.

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 i

[Peter_Cammaert]

Can you post a screenshot of the output you want, based on the data set you posted (for example an Excel example)?

[Anonymous]

may be like this:

Use as a Calculated Dimension:

=only({<Date=, Date={'>=$(=Date(max(Date)-3),'DateFormat')<=$(=date(max(Date)),'DataFormat')'}>} Date)

make sure format should be same of your Date Field and Expression in Set analysis

And then your expression like:

=sum(Sales)

[Anonymous]

This will give you last 3 days, same way you can go for 5 days

[MayilVahanan · Accepted solution]

HI

Are you looking like Attachment?

[#6]

hi Balarj,

thanks for your answer,but it's not getting desired result.

[Anonymous]

Post a sample data or qvw

[#8]

Thank you vary much ramasamy.

regards

siva