In a straight table I am trying to display all the orgizations that have a support type of org

[#1]

In a straight table I am trying to display all the orgizations that have a support type of org

only({$<[Support Type]={'=Org'}>}Org)

[israrkhan]

Expression is not correct, try like below..

=only({$<[Support Type]={'Org'}>}Org)

[Anonymous]

Chris

Assuming org is a dimension then make it a Calculated Dimension something like :

     if ( org = 'Org' , org )

And then remember to tick the 'Suppress When Value is Null'.

Best Regards,     Bill

[Clever_Anjos]

If you have more than one Organization, Only will return null.

Try =concat({$<[Support Type]={'Org'}>}Org,',')

[#5]

still no luck here is the spreadsheet

Division	Supports	Support Type
D1	D2	Division

[#6]

Still no luck here is the spreadsheet

Division	Supports	Support Type
D1	D2	Division

[#7]

Still no luck here is the spreadsheet

Division	Supports	Support Type
D1	D2	Division

[#8]

When you say "support type of org", do you mean you want to see only instances where Support Type = 'Org' or just Support Type <> Null value?

If so, you could use smthg like this:

Only({$<[Support Type]={'*'}>}  Division)