Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
Posted: 05 May 2014 at 8:00am
you could try formula1 this month's sales if year(data.datefield) = year(currentdate) and month(data.datefield) = month(currentdate) then data.amount else 0
formula2 last year sales if year(data.datefield) = year(currentdate)-1 and month(data.datefield) = month(currentdate) then data.amount else 0
group on customer create 2 summaries sum(formula1) sum(formula2)
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum