I'd like to group a view on two columns at the same time. The first column contains a serial number. The second column, Related To, is a lookup pointing to the Serial Number column. What I'm looking for is a way to group the view so that any items with EITHER a serial number or a matching value in the Related To column are grouped together within the view.
Item Direction SN Related To Hiya Incoming 123 This Incoming 234 Is Outgoing 345 123 An Outgoing 456 234 Example Outgoing 567 123
The result of this would be something like the following:
+ 123 Hiya Is Example + 234 This An
For now I'm working under the assumption that Incoming items have a serial number only, while Outgoing will have both SN and Related To filled in. I'm assuming SPD is needed to get something like this to happen. Do you have ideas on how to make this happen?