Keeping an axis reference line fixed

[#1]

I have a listbox with the three categories A, B and C, a customer table with customers who either belong to category A, B, or C, and a table with sales that correspond to each customer.  I have a scatter graph with sales on the x axis and another value for the y axis.  I would like a reference line to be locked for the median sales values for the x axis for the category A, B or C selected. and not to change when the user subselects a customer which belongs to one of the categories.

Namely, I need the median of the sales values for all of the entries that correspond to category A to remain fixed, even though the user select a a subset of customers for that category.

[MayilVahanan]

HI

Add reference lines in the presentation tab.

or

Add trends line which is in the expression tab.

Hope it helps.

[sibin_jacob]

Hi,

First add a reference line in the presenation tab.

For that reference line, write a set expression excluding Customer_Name.

then go to to Axis Tab , check the Center on property of X-Axis and add the same set expression.

Thanks,

Sibin Jacob. C