Aggregation of loaded field values within groups

[Mt3]

Hi,

Is there a way of aggregating a field within groups without re-loading it?

Lets say I have a Field1 with values {a,b,c,d,e,f}. I would like to aggregate them randomly in groups {ab},{cd},{ef} , call them respective Group1, Group2, Group3. Which feature you would start with to accomplish this?

[Digvijay_Singh]

Do you want this in the chart? you may use subfield function to create new columns in the straight table by breaking it in different groups, not sure about the dynamic random grouping.

[Mt3]

Thanks for the response, I would like to use newly created groups as Filters.

Currently I can filter  with separate values of {a,b,c,d,e,f},  after grouping it would be perfect to be able to filter with Group1, Group2 and so on