Hi,
how can I create a line chart in SQL reports that has for instance years on X-axis with a measure like 'number of orders' on Y-axis and separate lines for the members of a second dimension like suppliers? In OLAP reports I can do that by simply dragging the suppliers in the lines, the years in the columns and number of orders in the measures. But is there a way to achieve that in SQL reports? |