Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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
Hi,
You can this if you sort by month and year;
SORT:
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
sum({$<Year={'2009'}>} InvoicedAmount)
sum({$<Year={'2010'}>} InvoicedAmount)