Ad Hoc Grouping in Analytics

Suppose you have Funds A, B, C, D, E F, G, H, I, and J

(Or maybe they're price types, or campaigns, or source groups, etc.)

Now, suppose you need to create a  widget which groups those funds together in a specific way that isn't covered by designation or any other database field. Maybe for this widget you need to see three buckets:

  • A,B,E,G 
  • C,D,I,J
  • F,H

Is there a good way to do this? Building a separate widget for each of the buckets isn't sufficient.

-Galen