Could you post your expected completed pivot given the data provided?

Did you read Jeff Moden's article about crosstabs/pivots in T-SQL?

"Not working" is not terribly helpful when diagnosing a query.
post the T-SQL for your query and maybe we can help.

For someone that's been here as long as...

Look up examples for CROSS APPLY and TOP...  Here's Itzik's example from Itzik Ben-Gan on SQL 2008

SELECT D.orderID, D.productID, D.qty
FROM Sales.Orders AS O
CROSS APPLY 

use a correlated subquery and [NOT] EXISTS to find parent records with/without child records.  Just too lazy/tired to sort out the mess without sample data.

Got some table definitions and some sample data and some expected results? You know, same old same old.

False. This is an SSIS question.

your stored procedure won't even compile.  Besides, there's no declaration of your output parameter.  It's declared just like an input parameter, but it's got an OUTPUT tag on it.

CREATE TABLE DBs(Environ VARCHAR(4), SQLVersion VARCHAR(14));

SELECT Environ, SQLVersion, COUNT(*) AS Count
FROM DBs
GROUP BY Environ, SQLVersion;

Like this is one way...
CREATE TABLE #Test(
RowID INT IDENTITY,
EmpID CHAR(5) DEFAULT 'JDOE3',
ManagerID CHAR(6),
Yr INT,
...

Sounds like you are trying to do this with an INNER JOIN instead of an OUTER JOIN.  If you right-click on the join between the two tables, you can change...

look at RANK() and DENSE_RANK() windowing functions

what is the Value of all Approvals for Payments made in Year 2017

...Where is your Calendar table? Then you can do time-based summaries, like this:

[code...

So where does [BuyMultiplier] fit into the answer?  How does it change the expected result?  If you group by both ModelNo and BuyMultiplier, you will get one record for each...