How to use windowing functions with aggregates ? Hi, I have problem - to avoid separately computed aggregates calculated on some level and joining them back I want to use windowing functions which are now implemented by many database vendors. I have tried in AC using expression likemax(@eff_dt , PartitionBy(@col1,@col2,@col3))which parses well but unfortunately it was converted to something likemax(W0.tsEff_dt , PARTITION BY W0.dCol1 , W0.sCol2 , W0.sCol3)which of course result in error and it should be likemax(W0.tsEff_dt) over PARTITION BY W0.dCol1 , W0.sCol2 , W0.sCol3)is any way to get this ? regards