I have a Pivot table with tons of Expense information. The data source is a remote database containing millions of lines of information, with about 800 columns, so very large.

There's one field I want to filter, "Desc", and what I'm looking for is "services" for Group, Family, or Individual. However there are no entries for "Group Services" per se. I have plenty of "group home services", which I would want in my final results, but I also have "printing services", "translation services", "Weekly study Group", "Family income Calculator", etc which I do not want in my final results.

So, what I'd like to do is filter "Desc" once for "Services", and then within that filter for "Group", then "Family", etc. However, I can't figure out how to bring "Desc" in twice. If my source was a worksheet I could simply duplicate the column with a new name, but I don't have that option with a remote data source. So how do I do it?