Oracle Read ---- Transformer ------ Aggregator -------Transformer
I now need to populate a new field, YTD, with cumulative monthly totals eg:
MONTH MTD YTD
200801 10 10
200802 20 30
200803 30 60
etc
Does anybody have a nice elegant solution? Actually, just a solution would do.... I have searched the database but haven't found anything obviously pertinent....
![Rolling Eyes :roll:](./images/smilies/icon_rolleyes.gif)
Thanks