You have to think of views not in terms of "pulling", but rather in terms of Filtering and Organizing.
The first stage, Filtering, selects which files will be shown in the view. Either a file will be included or excluded. There's no later "pulling" additional items based on some criteria (the sole exception is the ~a search query modifier).
The second stage, Organizing, simply uses the files that are in the view, and organizes them according to the rules you've created. These rules may be based on file properties, or some other arbitrary set of values.
if you want compilation artists to appear in view (3), then Filtering must include such (e.g. not filter-out these items). So the question required now, is it safe to assume your compilation albums use Artist for Lou Reed and Album Artist is empty or set to some single album artist value?
If so, then it should be the case that Artist is Lou Reed and Album Artist (auto) is not "(Multiple Artists)" for primary albums, and for compilation albums, Artist would be Lou Reed but Album Artist (auto) would not be Lou Reed. This is a simple If() test. And if your Organizing rule outputs Compilations\[Album] in this case, instead of Albums\[Album], you'll get the organization you want. So your album level instead of being the simple Album field would instead be the (untested) expression:
if(isequal([Artist], [Album Artist (auto)]), Albums\[Album], Compilations\[Album])&datatype=[list]