How to display only Organizations that use both types of a Software not just one or the other.

[Anonymous]

Name_Org	Software
X	AutoCad
X	Autodesk
Y	Autocad
z	Excel
Y	Excel

Hello I would like to create a master dimension that will display Organization names that use 2 types of Software not just one or the other. For example I want only organizations that use Autocad AND Excel. What would be the function for this? Something like

Aggr(If(Software=Excel AND Softarwe= Autocad, Name_Org), Name_Org)

[isingh30]

Try this -

only({< Software = {'Excel'},{'Autocad'}>}Name_Org)

Thanks.

[Anonymous]

I get erron in expression:error in set modifier expression

[Chanty4u]

may be this?

only({< Software = {'Excel','Autocad'}>}Name_Org)

[Anonymous]

the expression is correct but i get invalid dimension

[Chanty4u]

use the correct dimension which you needed

[Anonymous]

I do but I get no result

[passionate]

Please provide some sample data.

[isingh30]

Please share your data in excel sheet.

Thanks

[Anonymous]

I editted