Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good morning All,
I have data which begins in August 2014 and ends in January 2015. I have created my calendar and have a bar graph by month. This shows January as the first month. How can I get the graph to show January as the last month so as to keep the graph in sequence?
Thanks
H
Hi Herbert
There are a few ways you can use, probably the simplest is to concatenate Month-Year together and then plot on a chart and/or add a sequence number in the script within your calendar dimension and sort by this on the chart.
Hope this helps
You can create a field containing Year and Month like this:
YearMonth
Year(Date) & '-' & Month(Date)
When you use this field as a dimension it will sort correctly - by Year and then Month ...
Hi,
In Sort option use Year field and select Ascending.
Regards
Anand