Suppose I have data from 2012 to July 2013, I would want an expression to calculate sales from inception that's the entire 2012 and 2013 up to June only.
try like this
where vStartDate = Min(Date)
vEndDate = MonthEnd(AddMonths(Max(Date),-1))
Retrieving data ...