I have some problems (maybe very basic) with selections.
I have a field: Sales_Month. This field contains months from 2002 till current date, loaded from the sales date records.
1) it doesn't contains all the months, if the firm has not sell anything on march 2008 I don't load Mar 2008. What I have to do in order to load all months?
2) I need a graph with years > 2009 only so I want a list box containing Sales_Month field, but it should show only 2012, 2011, 2010 months.
3) I want to make this condition editable by the users: for example the user could set 2010 and the graphs and the listbox will show only 2012 and 2011 months.
4) I need a graph that shows a 12 months rolling range. The user set a month for example jun 2010, and the graph shows the sales trend from jun 2010 to may 2011 only!!!
I'm sorry if these question are too basic and if I don't speak english very well.
