Topic: compare with same period last year Posted: 20 Jul 2010 at 6:33am
Hi All
i at beginners level in CR 2008 and have a problem.
i need to make a report that compares sales figures year to date with the same period last year.
I managed to get my selection formula correct.
{INVOICE_DATE} > Dateadd ('d',1,(currentdate) - (datepart("y",currentdate)))
or
{INVOICE_DATE} in dateadd('yyyy',-1,Dateadd ('d',1,(currentdate) - (datepart("y",currentdate)))) to Dateadd('yyyy',-1,(currentdate))
but how do i group on the date so i get this layout
period revenue
2009-01 2154
2010-01 2568
2009-02 1487
2010-02 1458
and so on.
Hope someone can point me in the right direction
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