Variable dimensions on x- and y-axis

[#1]

I guess this newbee questions was ask a hundered times - but I didn't find something. So the question:

I have a table with saledate, product, amount (per date/product).

I would like to have a linechart, where on the x-axis is the product, on the y-axis is a date vale. In the chart itself is the amount (accumulated for product/date).

Although there's a select box for product and date, the Linecahart should show selected products (or all) and selected date range, so both, x- and y-axis must be dynamic.

Is there some example or tutorial how to create this kind of chart?

Any help will be grateful

Tom

Addition:

I made a picture of what I'm thinking of:

But during outlining this I though this presentation would be to confusing to the viewer. So I guess a grid view will be a good solution.

[#2]

Hi Tom ,

I dont think so you can do it using Line Chart but you can achieve it using Grid Chart.

Regards,

Chakravarthy.

[johnw]

The Y-axis in the chart you show isn't a product; it's a total amount for a product and month. Other than having labels next to the lines (which isn't supported), that makes it a simple two-dimensional line chart. Dimension 1 = salemonth, dimension 2 = product, expression = sum(amount).