The release notes for 5.1.X indicate that PivotGrids can now summarize by ListAgg function. I'm on 5.1.3.179 (32 bit) and connecting to Oracle.
I have a dataset of ORDER_NUMBER, ORDER_LINE_NUMBER, LINE_ITEM_PART_NUMBER, PART_TYPE.
In the pivot I want to see the ORDER_NUMBER, and then a column that uses ListAgg to show the various PART_TYPE's on each order.
Example of desired outcome:
I put ORDER_ID in Row Area and PART_TYPE in the Data Area, but when I right-click on PART_TYPE to switch it from Count to ListAgg, ListAgg is not a choice.