By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| rn | name | value_ |
|---|---|---|
| 1 | dim1 | 100 |
| 2 | dim1 | 150 |
| 3 | dim1 | 200 |
| 4 | dim1 | 150 |
| 5 | dim1 | 100 |
| 6 | dim1 | 50 |
| 7 | dim1 | 0 |
| 1 | dim2 | 600 |
| 2 | dim2 | 700 |
| 3 | dim2 | 500 |
| rn | name | value_ |
|---|---|---|
| 1 | dim1 | 100 |
| 2 | dim1 | 150 |
| 3 | dim1 | 200 |
| 4 | dim1 | 150 |
| 5 | dim1 | 100 |
| 6 | dim1 | 50 |
| 7 | dim1 | 0 |
| 1 | dim2 | 600 |
| 2 | dim2 | 700 |
| 3 | dim2 | 500 |
| 4 | dim2 | 0 |
| 5 | dim2 | 0 |
| 6 | dim2 | 0 |
| 7 | dim2 | 0 |