Is it possible to use a column value as the argument to a hypothetical-set aggregate function?
If you include ID I would assume that you can join it back to itself on ID to get that information in one dataset.