TRANSFORM Min(X.N) AS [Min-N]
SELECT Y,Users, P, ord
FROM (SELECT Y,Users,P,StageProject,ord,Count(1) AS N FROM  qdfSRC GROUP BY Y,StageProject,Users,ord,P
	UNION ALL 
	SELECT T.Y,T.Users,T.P,T.StageProject & "Проц",T.ord,Round(Count(1)/Min(S.N)*100) FROM  qdfSRC T INNER JOIN 
	(SELECT Y,Count(1) AS N FROM  qdfSRC GROUP BY Y) S ON T.Y=S.Y
	 GROUP BY T.P,T.Y,T.Users, T.StageProject,T.ord   
	)  AS X
GROUP BY Y,Users, ord,P
ORDER BY Y, Users,ord
PIVOT X.StageProject In ('Реализация*','Реализация*Проц','Отказ','ОтказПроц','Выслано предложение','Выслано предложениеПроц','Получен запрос','Получен запросПроц','Подтвержден подгот-ка*','Подтвержден подгот-ка*Проц');

SELECT UserName1 AS Users, Amount AS AmountPrice, CostAmount AS AmountCost, MarjzaAmountCalc AS Marja, DealStage AS StageProject,  "Поступившие заявки" AS P, 1 AS ord, Year(DateClosed) AS Y
FROM qdfDeals;

 
TRANSFORM Min(X.N) AS [Min-N]
SELECT Y, Users, ord
FROM (SELECT Y,Users,StageProject,ord,Count(1) AS N FROM  qdfSRC2 GROUP BY Y,StageProject,Users,ord
	UNION ALL 
	SELECT T.Y,T.Users,T.StageProject & "Проц",T.ord,Round(Count(1)/Min(S.N)*100) FROM  qdfSRC2 T INNER JOIN 
	(SELECT Y,Count(1) AS N FROM  qdfSRC2 GROUP BY Y) S ON T.Y=S.Y
	 GROUP BY T.Y,T.Users, T.StageProject,T.ord   
	)  AS X
GROUP BY Y, Users, ord
ORDER BY Y, Users, ord
PIVOT X.StageProject In ('Реализация*','Реализация*Проц','Отказ','ОтказПроц','Выслано предложение','Выслано предложениеПроц','Получен запрос','Получен запросПроц','Подтвержден подгот-ка*','Подтвержден подгот-ка*Проц');

SELECT UserName1 AS Users, Amount AS AmountPrice, CostAmount AS AmountCost, MarjzaAmountCalc AS Marja, DealStage AS StageProject, 1 AS ord, Year(DateClosed) AS Y
FROM qdfDeals;

SELECT * FROM [color=red](TRANSFORM[/color] Min(X.N) AS [Min-N]
SELECT Y, Users, ord
FROM (SELECT Y,Users,StageProject,ord,Count(1) AS N FROM  qdfS2 GROUP BY Y,StageProject,Users,ord
	 )  AS X 
Group BY Y,Users, ord
 PIVOT X.StageProject In ('Реализация*','Реализация*Проц','Отказ','ОтказПроц',
'Выслано предложение','Выслано предложениеПроц','Получен запрос','Получен запросПроц','Подтвержден подгот-ка*','Подтвержден подгот-ка*Проц')) qdfS2
Left join (TRANSFORM Min(X.N) AS [Min-N]
SELECT Y, Users, ord
FROM (SELECT Y,Users,AmountPrice,ord,Count(1) AS N FROM  qdfSRC2 GROUP BY Y,AmountPrice,Users,ord
	 )  AS X 

Group BY Y,Users,ord
 
PIVOT X.AmountPrice In (' Цена')) qdfSCR2 ON qdfS2.Users=qdfSRC2.Users

SELECT UserName1, DealStage, 'Поступившие заявки' AS P,(Select Format(DateClosed,"yyyy") From [color=blue](SELECT tblDeals.ID, tblDeals.DealTitle, tblDeals.DealStage, tblDeals.Amount, tblDeals.DateClosed, tblDeals.Notes, tblDeals.UserName1, tblDeals.AddTime, tblDeals.CompanyID, tblMain.Company AS CompanyCalc, tblDeals.RefuseReasons, tblDeals.StartTimes, tblDeals.CalcSave, tblDeals.FinishTimes, tblDeals.AmountPeople, tblDeals.Smeta, tblDeals.Offer, tblDeals.ContactPersonID, tblContacts.ContactNames AS ContactPersonNameCalc, tblContacts.ContactSurnames AS ContactSurnameCalc, tblContacts.Email AS ContactEmailCalc, tblContacts.Phone AS ContactMobileCalc, tblDeals.ServiceKind, tblDeals.CostAmount, Amount - CostAmount AS MarjzaAmountCalc, tblDeals.Attantion, tblDeals.CheckDeal, tblDeals.FeedBack, tblDeals.DealsResourse, tblDeals.CompanyType, tblDeals.ManagerPay, tblDeals.PhotoLink, tblDeals.RefuseResults 
FROM (tblDeals LEFT JOIN tblMain ON tblDeals.CompanyID = tblMain.ID) LEFT JOIN tblContacts ON tblDeals.ContactPersonID = tblContacts.ID 
)[/color] tblSRC2 [color=red]Where 
tblSRC2.UserName1= tbl2SRC.UserName1 AND DealStage='Реализация*') AS Y,[/color]Count(1) AS ord 
FROM [color=blue](SELECT tblDeals.ID, tblDeals.DealTitle, tblDeals.DealStage, tblDeals.Amount, tblDeals.DateClosed, tblDeals.Notes, tblDeals.UserName1, tblDeals.AddTime, tblDeals.CompanyID, tblMain.Company AS CompanyCalc, tblDeals.RefuseReasons, tblDeals.StartTimes, tblDeals.CalcSave, tblDeals.FinishTimes, tblDeals.AmountPeople, tblDeals.Smeta, tblDeals.Offer, tblDeals.ContactPersonID, tblContacts.ContactNames AS ContactPersonNameCalc, tblContacts.ContactSurnames AS ContactSurnameCalc, tblContacts.Email AS ContactEmailCalc, tblContacts.Phone AS ContactMobileCalc, tblDeals.ServiceKind, tblDeals.CostAmount, Amount - CostAmount AS MarjzaAmountCalc, tblDeals.Attantion, tblDeals.CheckDeal, tblDeals.FeedBack, tblDeals.DealsResourse, tblDeals.CompanyType, tblDeals.ManagerPay, tblDeals.PhotoLink, tblDeals.RefuseResults 
FROM (tblDeals LEFT JOIN tblMain ON tblDeals.CompanyID = tblMain.ID) LEFT JOIN tblContacts ON tblDeals.ContactPersonID = tblContacts.ID 
) [/color]AS tbl2SRC 
GROUP BY UserName1, DealStage, Amount

SELECT UserName1 AS Users, DealStage AS StageProject, "Поступившие заявки" AS P, Amount AS AmountPrice, Cost AS AmountCost, 1 AS ord, Year(DateClosed) AS Y, Marja 
FROM qdfDeals
 

SELECT Deals5.*, 
(Select Count(*) FROM qdfDeals Deals2 WHERE Deals2.UserName1= Deals5.UserName1 AND year(Deals2.DateClosed)=Deals5.Year ) AS AllQuantity,
(Select Sum(Amount) FROM qdfDeals Deals1 WHERE Deals1.UserName1= Deals5.UserName1 AND DealStage='Реализация' AND year(Deals1.DateClosed)=Deals5.Year ) AS [SUM], 
(Select Sum(CostAmount) FROM qdfDeals Deals3 WHERE Deals3.UserName1= Deals5.UserName1 AND DealStage='Реализация' AND year(Deals3.DateClosed)=Deals5.Year ) AS Cost, 
(Select Sum(MarjzaAmountCalc) FROM qdfDeals Deals4 WHERE Deals4.UserName1= Deals5.UserName1 AND DealStage='Реализация' AND year(Deals4.DateClosed)=Deals5.Year ) AS Marja 
FROM (SELECT UserName1, DealStage, Count(*) AS Quantity, Year(DateClosed) AS [Year] FROM qdfDeals GROUP BY UserName1, DealStage, Year(DateClosed)) AS Deals5;
 

TRANSFORM MIN(N)
SELECT Y, Users, AllQuantity, SUMMA
FROM (SELECT Y, Users, StageProject ,AllQuantity, SUMMA, Count(Quantity) AS N FROM qdfSRC GROUP BY Y, Users, StageProject,  AllQuantity, SUMMA)  AS X
GROUP BY Y, Users, AllQuantity, SUMMA
PIVOT X.StageProject In ('Реализация','РеализацияПроц','Отказ','ОтказПроц','Выслан предложения','Выслан предложенияПроц','Получен запрос','Получен запросПроц','Подтвержден подгот-ка*','Подтвержден подгот-ка*Проц');

TRANSFORM MIN(N) 
SELECT Y, Users, AllQuantity, SUMMA, Cost, Marja
FROM (SELECT Y, Users, StageProject ,AllQuantity, Sum(Quantity) AS N,SUMMA,Cost, Marja  FROM qdfCd GROUP BY Y, Users, StageProject, AllQuantity, SUMMA,Cost, Marja 


[color=green]UNION ALL 
	SELECT T.Y,T.Users,T.AllQuantity,T.SUMMA, T.Cost,T.Marja,T.StageProject & "Проц",Round(Sum(Quantity)/Min(S.N)*100) FROM  qdfCd T INNER JOIN 
	(SELECT Y,Sum(Quantity) AS N FROM  qdfCd GROUP BY Y) S ON  T.Y=S.Y
	 GROUP BY T.Y,T.Users,T.AllQuantity,T.SUMMA, T.Cost,T.Marja,T.StageProject[/color]


) AS X 
GROUP BY Y, Users, AllQuantity, SUMMA,Cost, Marja 
PIVOT X.StageProject In ('Реализация*','Реализация*Проц',
	'Отказ','ОтказПроц','Выслано предложение','Выслано предложениеПроц','Получен запрос',
	'Получен запросПроц','Подтвержден подгот-ка*','Подтвержден подгот-ка*Проц');