Thanks Martin,

Being new to MDX, i usually start off with the Designer then modify the query as needed. Probably not best practice...

In regards to creating the named set, i understand what you are saying, but How do i create a named set that will get me the records where either of the 2 fields has the value I am looking for?

Again, i would need the set to do something like [Account Broker - Big 6] = "Marsh" OR [Account Broker Previous - Big 6] = "Marsh" and then only return the records that match that criteria. But I also want to show both those fields as columns.

Scott