Multiple line chart - add new calculated line.

[#1]

Hi!

I have a multiple line chart in QV. It has 2 dimensions and 1 expression.

Dimensions are 'Month' and 'Indicator'. Indicator can have 4 values ('A','B','C','D').

The expression is the sum of the field 'Amount' for each indicator.

And this is working OK, I have the chart with the 4 different lines displayed correctly.

My problem is:

I would like to create an additional line in the chart that displays the sum of the field 'Amount' when indicator is either ('A' or 'B'). Basically the sum of both indicators in a new different line in the chart.  Can you help me?

Thank you!!

[settu_periasamy]

May be like this..

=sum({<Indicatior={'A','B'}>}Amount)

[#3]

If I add this new additional expression maintaining the old expression, it won't show any chart. If I replace the old expression with this new one it plots 2 lines.

Do you know how to get the sum of both indicators in one line? Is it possible to plot the 2 expressions (5 lines in total) in the same chart?

Thanks!!

[#4]

Anyone?

[settu_periasamy]

is it possible to post the sample qvw file?.

May be you can add the A and B value sum in the Script .

Then it should shows the value like

Indicator

A,

B,

C,

D,

AB