Hi, There is solution - but very, very slow for daily summing, better for month, good for quarter or year summing For e.g. data for 2014, 2015 years "Quantity" - aggregated measure "Date" - calendar data 1. YearNo = Year('Date'n) measure 2. QtyYTD = CumulativePeriod(_Sum_, 'Qty'n, 'Date'n, _Inferred_, _ByYear_, 0, _Full_, {Date}) aggregated 3. QtyPrevYear = IF ( Avg [_ByGroup_] ('YearNo'n) = 2014 ) RETURN 0 ELSE ParallelPeriod(_Sum_, 'Qty'n, 'Date'n, _ByYear_, _ByYear_, -1, _Full_, {Date}) aggregated 4. Qty2YTD='QtyPrevYear'n + 'QtyYTD'n aggregated - gives sum we are looking for Best Regards Robert R.
... View more