Did this ever get fixed? Since we can't nest select functions, I need to do different group by clauses in separate queries to get data into one table. For example, I need the 6mo aggregate average and another calculation to get another number based on if that average is above or below a specific threshold. Thanks