The best way is to use Custom Sql and Pull in the Data.Use Custom SQL to retrieve data after properly applying all filters.
Ok how does one do that?
<edited out link>
John - just a note - that if your replies have links to sites not whitelisted (such as the previous reply) they will not be accepted. This is just to prevent spam. I am guessing it was in your signature line from outlook. I fixed this and approved the post.