Forum Discussion

ChrisNewsome's avatar
ChrisNewsome
Qrew Captain
6 years ago

Report showing comparison for sales per month this year vs. last year

So I've hunted around and haven't been able to find an answer to this so far. I'd like to make a comparison so we can see how we're doing compared to last year. So I'd like to have a report where I ca...
reports and charts
BrittanyLipinsk's avatar
BrittanyLipinsk
Qrew Trainee

Mark beat me to it.  I used a Report Formula and added this in there to show months:

Case(Month([Date of Booking]),
1,"01 Jan",
2,"02 Feb",
3,"03 March",
4,"04 Apr",
5,"05 May",
6,"06 June",
7,"07 July",
8,"08 Aug",
9,"09 Sept",
10,"10 Oct",
11,"11 Nov",
12,"12 Dec")




**I will say, I ended up settling on a line graph instead of a bar graph; the overall look of it is sooooo much cleaner:





------------------------------
Brittany Lipinski
------------------------------
WayneOliva's avatar
WayneOliva
Qrew Member
2 years ago

Thanks for replying so quickly!
That worked like a charm.



------------------------------
Wayne Oliva
------------------------------