Open
Description
Request for UNPIVOT in Data Grid
Currently we can do Pivot easily in Data Grid, it will be great if we can do unpivot also
Currently we have 4 Columns : Quantity, Price, Amount, Profit. We need to Unpivot this and make it into Rows
User should be able to provide the Grouped Column Name and Grouped Column Value name like below
Please let me if this is something possible in current Data Grid.
I know we can do this at data ingestion level, but if you already have data in the table then its painful to re-ingest data again and then create reports and it is too much pressure to RAM to unpivot the data while ingesting. So much better is at client level using perspective library
Thanks
Ritesh