I am attempting to show a bar chart with one year's invoices compared to the next year's. I would like to show this over a full twelve months.
This is best described in the attachment. What needs to be done is to keep Jan-09 next to Jan-10 rather than Jan-09, Feb-09 etc.
Thanks for your help
You can this if you sort by month and year;
check expression, and put MONTH(date), Year(date)
Change your dimension, use just Month not Month-Year.
Create 2 expressions with set analysis, on for 2009 and one for 2010
Retrieving data ...