2 dimension with 3 expression

[#1]

Hi every one,

I want create a Line chart with 2 dimension ; Year & Month and 3 expression .

I want when i choose 2 years from year listbox , in chart i see 6 trends

Dimension axis show month of year and Expression axis show 6 trend line ; for each expression we have 2 trend line.

How can i do this ?

With Best Regards

Hamide

[Gysbert_Wassenaar]

That's not possible. A line chart can have only two dimensions and one expression or multiple expression with a single dimension. You'll have to either use two charts or combine the two dimensions into one: =DimA & '-' & DimB

[stigchel]

Hi Hamide,

If you want to see six lines, you can't do that with two dimensions and three expressions. You can use six expressions (or more when more years are selected) and use for example the following in each of the two sets of three:

1st set

Sum({<Year={'$(=Max(Year))'}>} Sales)

2nd set

Sum({<Year={'$(=Max(Year,2))'}>} Sales)

...