How to Use WPS Data Table Grouping on Android

Use these 4 how-to topics to add grouping, set grouping order, add multiple grouping conditions, and remove grouping; all 4 topics are available without membership.

How-to Guide

How-to Index

Instructions

1. Add grouping

Entry path: Bottom toolbar → Tools → Group → Add grouping condition

1. Open the data table and tap Tools on the bottom toolbar.
2. Select Group.
3. Tap Add grouping condition.
4. Choose the field you want to use for grouping.
5. Tap Confirm to apply the grouping.

Expected result

• The table is grouped by the selected field.
• You can continue to expand groups, review records, or add another grouping condition.
• The original record content is unchanged.

Notes

• If you are not in a data table view, the grouping entry may not appear.
• Make sure the current Android view supports grouping.

2. Set grouping order

Entry path: Bottom toolbar → Tools → Group → Add grouping condition

1. Open the Add grouping condition screen.
2. Select the target field.
3. Choose Option order or Reverse option order as the sort rule.
4. Tap Confirm to apply the grouping and order.

Expected result

• Groups are displayed in the selected order.
• You can continue adjusting other grouping conditions.
• Only the display order changes; record content is not affected.

Notes

• If you choose a field but do not pay attention to the sort rule, the result may not match your preferred order.
• It is usually easier to set the order while adding the grouping condition.

3. Add multiple grouping conditions

Entry path: Bottom toolbar → Tools → Group → Add grouping condition

1. Add the first grouping condition.
2. Tap Add grouping condition again.
3. Select a second field and choose its sort rule.
4. Tap Confirm to save it.
5. Repeat these steps if you need more grouping levels.

Expected result

• The data table shows a layered grouping structure.
• You can expand each level or remove a specific grouping condition later.
• The current view is reorganized without changing the original records.

Notes

• Too many grouping conditions can make the hierarchy longer to review on a phone screen.
• Layered grouping is easier to review when field values are clear and categories are consistent.

4. Remove grouping

Entry path: Bottom toolbar → Tools → Group → Delete

1. Open the data table and tap Tools.
2. Select Group.
3. Find the grouping condition you want to remove.
4. Tap Delete next to that grouping condition.

Expected result

• The selected grouping condition is removed.
• The table returns to fewer grouping levels or a simpler view.
• Removing grouping does not delete records or change the original data content.

Notes

• Deleting a grouping condition is different from deleting a record.
• In a shared table, the grouped display can be visible to collaborators.