Single select dimension on Straight table

[mayankraoka]

Hi Team,

I have a to restrict the dimension customer name as single select on grid(Straight) report.Assume the below scenario:

I have straight table with customer as dimension and metrics as Volume and,Growth ...

Now I want user to have permission to select only 1 customer from grid report.I dont have list box filter for customer.The only way user can select is from Chart.Is there any way we can do that?I know 1 way where we can restrict to select 1 customer and if they select more than one customer chart will get disabled.But is there any better way without disabling chart?

Any help will be appreciated.

Regards,

Mayank

[swuehl]

You could try creating a trigger on field selections that fires a select in field action for the customer field that will clear the customer selections if more than one value is selected (or restrict the selection to a single value e.g. to the first selected customer in load order).

[mayankraoka]

Hi swuehl,

Can you please demonstrate how to achieve this?

Regards,

Mayank

[swuehl · Accepted solution]

Maybe like in this sample QVW. Try to select in the chart more than one SalesBranch.

[mayankraoka]

Thank you very much Swehl that work .....