Pivot table conditional filtering?

[KimberlyWelty]

I am not sure that a pivot table is the best way to do this or not, so looking for a suggestion. I also thought a slicer might work, but not sure how to do this.
I have a list of customers in a database with revenue. In that same database, there are multiple locations.
I am trying to figure out how to easily pull the following information:
- The customer revenue when they have revenue in multiple locations - though with one location specifically + any other location.
- The customer revenue when they have revenue in multiple locations - though without one location specifically.

Here is some sample data, there are more columns of information such as year, month, etc.

1) I want to be able to quickly show all customers revenue by location but only show the customer and the detail by location, if they have revenue from Location 2
2) I also need to be able to quickly show all customers revenue by location but only if they do not have revenue from Location 2.

Note; the data file has almost 400,000 rows of data and 42 columns as well. Any suggestions would be greatly appreciated.