I am building a line chart. X axis is Quarter and Y is Revenue (bar chart) and growth (line chart).
I chosed the line chart. I have one dimension Quarter, and two expressions. I would like sum(Revenue) be in bars. but the option 'bar' in tab Display Option is grayed...
why is it so ?
I want to display revenues for Q1 2012, Q2 2012, Q3 2012, Q4 2012, Q1 2013 etc... quarters and years are two separate dimensions. if i set year and quarters as 2 dimensions for the chart, it is displaying four line charts and X axis are years. how can i build this line chart ?