I am looking to see if DevExtreme React datagrid can do what I am trying to do. Basically, using my source table, I am trying to create a results table saying the following:
1st column = grouping by product
2nd column = sum quantity where id = a
3rd column = sum quantity where id = b
Is that possible in Devextreme functionality?
SOURCE TABLE
| product | id | quantity |
|---|---|---|
| gold | a | 1 |
| gold | a | 1 |
| gold | b | 2 |
| silver | a | 3 |
| silver | a | 3 |
| silver | b | 4 |
RESULT TABLE
| product | idA | idB |
|---|---|---|
| gold | 2 | 2 |
| silver | 6 | 4 |
