I used to be able to do thios in Hyperion! Help me by making it easier in Toad Data Point
ListAgg still works in Toad if you are connected to an Oracle database. If you are connected to Sql Server it is a little more complicated but you can accomplish the same thing with Stuff and For XML Path (see this link: https://stackoverflow.com/questions/31211506/how-stuff-and-for-xml-path-work-in-sql-server ). It is database dependent not Toad dependent. I prefer ListAgg but I am not using Oracle right now 
Completed in T&C in Toad Data Point