Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts,
i have one date field in my data.and some id,sales of data is there.
here if i select any date it has to go 7 days back for example
if i select 07/01/2005 it has to show 01/01/2015 and 07/01/2005 dates. remaining in between of dates it will not show.
same way if i select 01/01/2015 it has to show 25/12/2014 of data and 01/01/2015 of data. remaining in between of dates will not show.
i want show in chart level.
i have some ideas but those ideas are not giving proper result.
any ideas.
thanks in advance
Replace InvoiceDate with your DateField Name
SUM({<InvoiceDate = {'$(=Date(Max(InvoiceDate)))'}>+<InvoiceDate = {'$(=Date(Max(InvoiceDate)-6))'}>}Sales)