I just completed this challenge and it's not working.

I've done everything according to the requirements and still get this message:
"Challenge Not yet complete... here's what's wrong:
The 'Sales Pipeline Overview' lens does not appear to have the correct query. Please check the requirements and ensure everything is setup correctly."



Also, the "Copy and Paste Results between Lenses" is no longer possible for me. Can't find copy or paste...

Can somebody please help me out here how to measure based on the sum of # instead of a count of rows or sum of the amount because on my case # is not appearing on the creating lens window Thanks in advance. PFB more details.
​