How to build "OR" relation filter in the dashboard?

[#1]

I like to find a way to create a filter with OR function --

when I choose a person name = "ABC" .. it will give me sales person name = "ABC" or engineer name = "ABC" ...

Please help!

Thanks!

[agni_gold]

could you please send some sample data or file?

[#3]

Thanks for the reply .. here is the example ..

[swuehl]

You can transform your Detail table from a cross table to a straight table using CROSSTABLE LOAD prefix:

CROSSTABLE( Role, Person)

LOAD ORDERS, BILLTO, PAYER, SHIPTO

FROM ....;

The Crosstable Load

Then you can use Person field to filter all records where Person appears in any Role.