Does anyone know how/if I can create a filter on a report that would show me only projects who's group (groupID) does not match the group for the portfolio (portfolio:groupID) the project is part of?
Here's your filter:
portfolio:groupID=FIELD:groupID
portfolio:groupID_Mod=ne
Here's your Portfolio Group Name column:
displayname=Folio Group
linkedname=portfolio
namekey=view.relatedcolumn
namekeyargkey.0=portfolio
namekeyargkey.1=group:name
querysort=portfolio:group:name
textmode=true
valuefield=portfolio:group:name
valueformat=HTML
TIP: if this solved your problem, I invite you to consider marking it as a Correct Answer to help others who might also find it of use.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.