Pivoting #510
Description
GroupBy could also allow pivot tables.
From:
+------+---------+------+
| Year | Product | Sale |
+------+---------+------+
| 2019 | A | 100 |
| 2019 | B | 200 |
| 2020 | A | 150 |
| 2020 | C | 300 |
| 2021 | B | 100 |
| 2021 | C | 150 |
+------+---------+------+
Through:
- Group by Year
- Pivot by Product
- Aggregate Sum by Sale
Into:
+------+----+----+----+
| Year | A | B | C |
+------+----+----+----+
| 2021 |null| 100| 150|
| 2019 | 100| 200|null|
| 2020 | 150|null| 300|
+------+----+----+----+
Metadata
Metadata
Assignees
Labels
No labels
Type
Projects
Status