Yes, this is definitely an issue we have all faced at one point in Workfront. 😉
So the bad news, you won't be able to do groupings on the "Other Teams" really since it is a multiple select field. Besides, it would look weird because you'd have grouping for each possible combination you had.
As for filtering, there are things we can do with EXIST filtering that has worked for me. Can you give me a little more detail about what reporting you are doing?
I probably have something similar I can give you to tweak and then copy and paste in. 😉
Hi Anthony, thanks for the help. This is a project report that is currently filtered by a home team ID. I had wanted to group by teams that actually roll up to that home team so they could see active projects by these smaller teams. If I can't group that way, perhaps I can filter by each team and then create a dashboard of each team report?
Hi Anthony. Do you have some text mode for filtering based on Other Teams?
I'm looking add a filter to a Task report where it displays tasks based on the user logged in ($$USER....???) and any tasks associated to the Other Teams they belong to.