Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

I want sales for top 5 date sales

  sum of Sales for latest 5 dates..Please note ..I want sales for top 5 date sales....also these dates need not to be consecutive...please see the raw data table here..I want to build bar chart showing top 5 dates


Raw Data Sorted Data I want top 5 latest dates (recent 5 dates)
Date_DSalesDate_DSales
7/28/2015195211/30/20161014Date_DSales
4/20/201636511/24/2016124111/30/20161014
7/3/201513279/14/2016147411/24/20161241
1/14/201618964/20/20163659/14/20161474
3/10/20167753/10/20167754/20/2016365
1/18/201518212/17/201610293/10/2016775
10/26/201512582/4/2016142
10/9/201517221/14/20161896
11/24/2016124110/26/20151258
9/14/2016147410/9/20151722
2/4/20161428/9/20151161
8/9/201511617/28/20151952
11/30/201610147/3/20151327
1/11/201516426/6/20151715
6/6/201517151/18/20151821
2/17/201610291/11/20151642
2 Replies
settu_periasamy
Master III
Master III

You can try this..

=sum({<Date_D={'>=$(=Date(max(Date_D,5)))'}>}Sales)


sample attached

sunny_talwar

This is the expression I provided you before (bar chart for sales with 5 latest dates)

Sum({<Date_D = {">=$(=Date(Max(Date_D, 5), 'M/D/YYYY'))"}>} Sales)

Capture.PNG