How can I create a line chart with 2 dimensions and one expression

[#1]

I want to create a line chart with 2 dimensions and one expression.  The problem I have is that there are two expressions in my object.

1) Active Rate 2) Cumulative Inactives.

I want to chart Active Rate by the two dimensions, however I cant remove Cumulative Inactives from the chart object as active rate uses this to calculate itself.

Just hiding Cumulative inactives does nt work.

Any help would be appreciated.

[stephencredmond]

Hi Lee,

Can you not just include the expression for Cum. Inactives in the expression for Active Rate?

Regards,

Stephen

[#3]

Thanks - that did help, I recoded my variable using the Rangesum function to get rid of the need for the 2nd variable.

I have another query now!

The Active rate calculates correctly when I show it as a pivot table, however when I turn it into a chart, the points show as a percentage of the previous data point, rather than the data when it is in a pivot table!

Any thoughts to why that might be?

(Seems to be something to do with having two dimensions as charts fine when I remove the 2nd dimension