Arif
One way to do this is to define two variables (assuming you have a date field called Date):
- vMinDate: =Min(Date)
- vMaxDate =Max(Date)
The use set analysis in the expressions to limit the data between these two dates. For example:
- Sum({<Date = {">=$(=Date(vMinDate)) <=$(=Date(vMaxDate))"}>} Sales)
If you have other date related fields linked to Date (such as Month, Year), you may need to override their selection with
- Sum({<Date = {">=$(=Date(vMinDate)) <=$(=Date(vMaxDate))"}, Year=, Month= >} Sales)
Regards
Jonathan
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
