I have a data set that can be simplified to four dimensions (RecordID, FM Hand, FMNumber and FMBarcode).
I wish to use a filter pane to select multiple different FMBarcodes.
The resulting table I want to create, shows one row for each filtered FMBarcode, and then in subsequent columns, the corresponding FMHand, FMNumber and RecordID. So far not a problem!
However, each record contains FMBarcodes that have a "Left" FMHand and a "Right" FMHand. I wish the final column to show the FMBarcode that has the same RecordID and same FMNumber as the first-column FMBarcode, but has the opposite FMHand.
I suspect that this is a set analysis problem. I have tried what I thought might be a slightly simpler approach, to list columns with the "Left" and "Right" FMHands, but the result meshes all possible FMNumber's with all possible RecordID's, when what I want is only the possible FM number within an individual Record ID, per row for each selected FMBarcode.
