Cognos Analytics includes many windowing aggregation functions - minimum (MIN), maximum (MAX), total (SUM), etc. Have Lead and Lag been included yet? I'm using 11.2.4 and still not finding these.
You can write your own SQL and use Lead ( <column name> ,1,0 ) over ( order by <column name> ) ;)
I know. But I was hoping to avoid custom, raw SQL.