---
url: /set-instructions/group-by-value-using-the-next-instruction-ascending.md
description: >-
  Groups the working set by the value the next instruction produces, inserting
  blank rows between groups. Workview column axis only.
---

# Group By Value Using The Next Instruction (Ascending)

**Workview-only. Column axis only.** Groups the working list (on the row axis) by the value produced by the *next* instruction, inserting a blank row between each group, ordered ascending by that value. Useful when you want to visually separate elements that share a categorisation but don't have a roll-up hierarchy expressing that grouping.

Like the [Sort By Value](/set-instructions/sort-by-value-using-the-next-instruction-ascending) instructions, it reads its grouping criterion from the instruction immediately after it, rather than carrying one itself.

#### Example

```
1. Element: All Sales Reps
2. Expand All
3. Remove Consolidations
4. Group By Value Using The Next Instruction (Ascending)
5. Insert Using Formula: LINK("Sales Reps", ["Region"])
```

Groups every sales rep by their Region, with a blank row separating each region rather than requiring a Region level in the hierarchy itself. See [Group By Value Using The Next Instruction (Descending)](/set-instructions/group-by-value-using-the-next-instruction-descending) for the reverse order.

![Group By Value Ascending and Descending compared against the same ungrouped working set](/set-instructions-example-group-by-value.svg)