How to display only Organizations that use both types of a Software not just one or the other.
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)