If wildmatch to return data for selected values

[#1]

Hi sorry guys I know this is a basic question but how do I return the names and associated data for say a list of people :

So say I've a list of names

PERSON, TRAVEL

tom, economy

bob, economy

jerry, business

mark, economy

adam, business

smith, business

So I want to show the names and the class of travel for all those who travelled 'business' ie jerry, adam and smith. I know this is a basic example but it will set me up going forward ... thanks

[Gysbert_Wassenaar]

Add a table box with both fields. Then click on the value 'business' to select it. The table box will show the persons who traveled business class.

[#3]

Sorry just to be clear I meant either as a calculated dimension or in script

[Gysbert_Wassenaar]

If you want to load only those records where the value of TRAVEL is 'business' you can use something like this as script:

MyTable:

LOAD PERSON, TRAVEL

FROM ...mysource...

WHERE TRAVEL = 'Business';

[mohammadkhatimi]

Hi,

Try this in Calculated Dimension:

if(TRAVEL='business',PERSON)

Regards,

Er.Mohammad