In Hyperion, data could be aggregated as a list (instead of a sum, average, etc.), like using Listagg functions, in the pivot. Is there a way to do this in Toad?
For Example...
Here is how data is listed in Toad's Pivot window.
CONTRACT CALC_CODE
0012345 10
0012345 30
0012345 31
0064197 10
Here is how we would like to see it listed.
CONTRACT CALC_CODE
0012345 10, 30, 31
0064197 10
