About EasyMorph Tutorials & Examples Web-help

Pivot / unpivot several sum of amounts

Hi,

Today in the pivot action, you have only one amount possible to sum. But imagine you have 2 amounts in your dataset, and one column with date. It would be good to be able to specify the 2 amounts in the action, and then the pivot create 2*(number of distinct dates) columns.
03/12/2020 | Amount 1 | Amount 2
=>
Amount 1 03/12/2020 | Amount 2 03/12/2020
(new naming convention necessary)

To learn more about EasyMorph visit easymorph.com.