Skip to Content
0
Former Member
Jan 20, 2012 at 10:50 AM

Annual Sales Comparison Analysis by Year - Query

771 Views

Hi,

I need some help please!

I need a query where I can compare sales to the previous year, preferably with manual date range entries.

CardCode u2013 CardName u2013 SalesX u2013 SalesY

Where the date range is the same but SalesY is for the corresponding time 1 year back.

I can get the individual totals for each year but I cannot get to combine the two years in one report.

Thanks.