Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi experts,
i have table like this
load * inline [
date, sales
1/1/2015,100
1/2/2015,200
1/3/2015,300
1/4/2015.400
1/5/2015.500
1/6/2015,600
1/7/2015,700
];
if i select 2 dates i.e 1/2/2015 and 1/6/2015 then i want see only middle date sales i.e 300,400,500. what is the way to approach?
Hi,
Try below expression.
Sum({<Date = {">$(=Min(Date)<$(=Max(Date)))"}>}Sales)
Regards,
Kaushik Solanki
Sum({$ <date={">$(=date(Min(date)))<$(=date(Max(date)))"}>} sales)
see attachment
Make sure that you Date field is in proper date format, else create the Date with date(date#(date, 'MM/DD/YYYY')) as date
then try below expression in set analysis
Sum({<Date = {">$(=Min(date)<$(=Max(date)))"}>}Sales)
This will work .