How to display only certain values in a table?

[#1]

Hello,

I am so new to this, and need your help.

This is my table

Cars	Country	Models
BMW	GER	12
TOYOTA	JPN	20
HONDA	JPN	18
NISSAN	JPN	15

I need to display information for just BMW and Toyota. How do I do that ?

Cars	Models
BMW	12
TOYOTA	20

I tried =if(match(Cars,'BMW', 'TOYOTA', ), Cars,'OTHER')

and added Expression sum(Models)

The problem with that one is that i don't want to display any other values but with my calculated dimension I get OTHER row. I don't want to show anything else.

Thanks a lot

[arulsettu]

try this

if(match(Cars,'BMW', 'TOYOTA' ), Cars)

[sunny_talwar]

I would recommend using set analysis:

=Sum({<Cars = {'BMW', 'TOYOTA'}>}  Models)

[tresesco]

Try removing an extra comma, like:

if(match(Cars,'BMW', 'TOYOTA'), Cars,'OTHER')

[Chanty4u]

try this

if(match(crs,'bmw','toyota'),cars)

[#6]

It looks like your calculated dimension has a comma after 'TOYOTA'. Can you please erase that and try?

[#7]

This did not work and produced the following error:

//Error in calculated dimension

[#8]

This produces the following table. Instead of other, it creates "-" sign.  I need to get rid of -/33 result.

Cars	Models
BMW	12
TOYOTA	20
-	33

[#9]

I need results without "OTHER"

[#10]

This produces the following table. Instead of other, it creates "-" sign.  I need to get rid of -/33 result.

Cars	Models
BMW	12
TOYOTA	20
-	33