13 Replies Latest reply: May 22, 2018 3:14 PM by Efthymios Kasvikis RSS

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

    Efthymios Kasvikis

      Screenshot_1.png

      Name_OrgSoftware
      XAutoCad
      XAutodesk
      YAutocad
      zExcel
      YExcel

      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)