I want to show the bar chart with year and month in x axis and sum(sales) in y axis in single graph..
like consider the year 2009 and 2010.....
i have the monthwise data....
i want to show the 2009 as first bar(i.e.,overall year),then i want to show the monthwise sales like jan,feb,...dec..then the final bar should show the 2010 overall sales....
totally i want to show the 14 bars in the chart...months are from 2009 only...
Without going into details, I can think of two possible ways: 1. Only front end. Create a bar chart without dimensions, and with 14 expressions - one for 2009, another for 2010, and for each month. 2. Using script and front-end. Create a logical table which has an artificial field with values 2009, months of 2010, and 2010. Another column in this table will be the amount aggregated appropriately for each period. Use it for your bar chart.
Can't tell what is better in your situation. I'd probably choose the first option in most cases.
