Ignore the string order when grouping

1. Problem description

When the order in the data group is different, the same group is displayed separately, as shown in the following figure:

The first line and the second line of Xiaoming Xiaoliang should belong to the same group, and now I want to merge them into one group display, as shown in the following figure:

2. Realization ideas

Sort the strings in the group first, and then group and summarize them.

1. Data preparation

Create a new normal report, create a new built-in dataset, as shown in the following figure:

2. Report design

1) Design the table as shown below:

2) Select cell C2, and set the data in the cell element to Summary and Sum.

3) Select cell A2, and perform custom grouping as shown in the figure below. Custom formula: JOINARRAY(SORTARRAY(SPLIT($$$,",")),",")

3. Effect preview

Save the report, click pagination preview, the effect is as shown in the figure below:

Note: Support mobile terminal.

For the completed template: %FR_HOME%\webroot\WEB-INF\reportlets\doc-EN\ReportApplication\BasicApplication\Ignore_string_order_when_grouping.cpt

Click to download:

Ignore_string_order_when_grouping.cpt