Trend lines based on selection fields

[raju_salmon]

Hi,

I have a trend line with Count(Customer) for all Stores.

My dimension is Year and expression is Count(Customer).

Now my trend line shows only one for all stores.

When i select more than one store from store list box, i need to get trend lines based on selection count.

For example, i have selected 3 stores in my list box and chart should show three line, can we show that?

Please help me on this.

Thanks,

Raju

[raju_salmon]

Can we use Stores as second dimension and can put any condition to display?

I am trying with below condition at dimension (enable condition) but not working.

=if(GetSelectedCount(Stores)<>0, Stores)

[sunny_talwar]

Not entirely sure, but may be add store as your second dimension

[Anonymous]

try to define a second Dimension as calculated dimension

=if(GetSelectedCount(Stores)<>0, Stores)

if you select 1,2 or 3 stores you should see 1,2, or 3 lines

using enabele condition will Show lines or no lines depending on condition and is not what you need

[swuehl]

Try this as enable conditional for the second dimension

=GetSelectedCount(Stores) > 1

to enable the dimension Stores when more than 1 store is selected (and use Stores as dimension to enable).

But this may not only show multiple trendlines, but also multiple bars / lines etc. for your different stores.