I've attached a quick solution.
Two notes though:
1. I only added one row from the missing external table (for the initial states)
2. The code relies on the fact that the Tstamp is always the same for two rows for "state" and "assigned_to" that are to be joined.
Hampus von Post
Billforsgrouping.qvw 151.5 K
Thanks alot, I just had a chance to look quickly but as I said the first problem I had was getting the propeties in place for the first step, the "group by" sequence.. Seems I had missed the Only() function.
Much appriciated. I think I can adapt this to my needs If not I might be back for some more help