co-related sub-query

[Former Member]

Hi Gurus,

In SQL I can easily create a co-related sub query, to return the maximum User_Id in each Department.

Can I do the same in an attribute view?

I tried by adding Max(User) id as a calculated field and Department as a regular field. This gave an error on activation. How do I tell an attribute view to do the equivalent of group by on the Department?

Thanks

Cliff

[Former Member]

Hi Cliff,

I think you can do this with analytic view instead of attribute view.

Best regards,

Wenjun