Specify Dimension's range of values to ignore one of the lines

[#1]

Requesting help on customizing a line chart. Let's say I have these dimensions and expression:

Dimensions:

     -Time

     -Product

Expression:

     -Price

There's a product called 'Reference' in my data, which is actually used as a reference line in the chart, but it needs to be treated as a product in the data.

I wish to specify my dimensions so that on the X axis, it will show the X values for all products EXCLUDING the reference line.

In other words, I want the X axis to ignore this 'reference line' and plot data within the domain of all other products.

What can I do?

[swuehl · Accepted solution]

I think you could either use

=if(Product <> 'Reference', Product)

as your second, calculated dimension, or use  set analysis in your expression, e.g.

sum({<Product -= {Reference}>} Price)

[#3]

Actually I wanted to keep 'Reference' in the chart.

If I use    =if(Product <> 'Reference', Product)

then I will lose the line for 'Reference' on my chart.

Is there a way to keep the line, but only plot within the Time for non-'Reference' products?

[swuehl]

Not really sure if I got you, maybe use

=aggr(only({<Product -= {Reference} >}Time) ,Time)

as calculated dimension instead of Time, to limit the Time values to values referenced by Products except Reference?

[#5]

Much helped! Thanks!