Hi

Thanks for your reply.

You've picked out the problems in the MDX I wrote, and I'm looking forward to trying out your suggestions on Tuesday when I'm back at work.

The problem is that I'm deliberately trying to aggregate the set in 2 ways at once in one query:

1. By PhoneLogin, Employee, for the measure total; and

2. By PhoneLogin only, to count the distinct instances of Employee per PhoneLogin (more than one per PhoneLogin is bad, I want to highlight these cases, and perhaps develop the query to return only them).

In SQL I'd do this with a CTE, going a GROUP BY PhoneLogin, Employee on it, and joining this query to a GROUP BY PhoneLogin (only) query, on PhoneLogin. So you're spot on with your "pseudo-cursor" comment: I'm asking the query to do the same thing twice.

Anyway, I'll try out your suggestions on Tuesday and post the results (hopefully a solution!).

regards

seb