Weeks	PG
201624	Cat1
201624	Cat2
201623	Cat1
201623	Cat2
201622	Cat1
201622	Cat2

Weeks	PG	SumValue
201624	Cat1	3311,13
201622	Cat2	757,25
201621	Cat3	2114,23
201620	Cat3	11456,66
201619	Cat2	11768,99
201617	Cat4	95,59

Weeks	PG	Res
201624	Cat1	3311,13
201624	Cat2	0
201623	Cat1	0
201623	Cat2	0
201622	Cat1	0
201622	Cat2	757,25

SELECT W.Weeks, W.PG, V.SumValue AS Res
FROM SelectPgWk AS W LEFT JOIN SelectPgWkVal AS V ON ((W.PG = V.PG) AND (W.Weeks = V.Weeks));

Weeks	PG	Res
201622	Cat1	
201623	Cat1	
201624	Cat1	
201622	Cat2	
201623	Cat2	
201624	Cat2	

Weeks	PG	Res
201624	Cat1	3311,13
201624	Cat2	0
201623	Cat1	0
201623	Cat2	0
201622	Cat1	0
201622	Cat2	757,25

SELECT Sum(StockValue.ResultValue) AS [Sum-ResultValue], StockValue.[Weeek] AS Week, StockValue.[Entity code] AS Entity, StockValue.StockDaysRangeShort AS StockDaysRangeShort, StockValue.[>60] AS Plus60, StockValue.[Product group] AS [Product group]
FROM Stock AS StockValue
WHERE (NOT StockValue.[Product group] = "LED Lighting" 
				     AND NOT StockValue.[Product group] = "Power Battery"
     				AND StockValue.[Entity code] IN (SELECT SAM_Entities_Selection.[Entity code] AS TargetEntity 
                                                       											FROM SAM_Entities_Selection))
GROUP BY StockValue.[Weeek], StockValue.[Entity code], StockValue.StockDaysRangeShort, StockValue.[Product group], StockValue.[>60];

SELECT ROUND(PgWk.Weeks,0) AS Weeks, TRIM(PgWk.PG) AS PG
FROM (SELECT Top3Weeks.Weeks, PGs.PG FROM Top3Weeks, (SELECT DISTINCT Val.[Product group] AS PG FROM SAM_ValueSumByWeeksByEntityByCategoryPastYear AS Val LEFT JOIN Top3Weeks AS T3W ON T3W.Weeks = Val.Week WHERE (NOT Val.[Product group] = "Cat0"  			AND NOT Val.[Product group] = "Cat1" 			AND Val.StockDaysRangeShort = "(180,360]" 			AND Val.Entity IN (SELECT SAM_Entities_Selection.[Entity code] AS TargetEntity FROM SAM_Entities_Selection) 			AND NOT IsNull(T3W.Weeks)))  AS PGs)  AS PgWk;

SELECT ROUND(SAM_ValueSumByWeeksByEntityByCategoryPastYear.Week,0) AS Weeks, TRIM(SAM_ValueSumByWeeksByEntityByCategoryPastYear.[Product group]) AS PG, ROUND(SAM_ValueSumByWeeksByEntityByCategoryPastYear.[Sum-ResultValue],2) AS SumValue
FROM SAM_ValueSumByWeeksByEntityByCategoryPastYear
WHERE (((SAM_ValueSumByWeeksByEntityByCategoryPastYear.StockDaysRangeShort)="(180,360]") AND ((SAM_ValueSumByWeeksByEntityByCategoryPastYear.Entity) In (SELECT SAM_Entities_Selection.[Entity code] AS TargetEntity FROM SAM_Entities_Selection)));

SELECT TOP 3 [%$##@_Alias].TopWeeks AS Weeks
FROM (SELECT DISTINCT (Stock.[Weeek]) AS TopWeeks FROM Stock ORDER BY Stock.[Weeek] DESC)  AS [%$##@_Alias];

SELECT W.Weeks, W.PG, V.SumValue AS Res
FROM SelectPgWk AS W LEFT JOIN SelectPgWkVal AS V ON ((W.PG = V.PG) AND (W.Weeks = V.Weeks));

SELECT TOP 3 Stock.Week AS Weeks
FROM Stock
GROUP BY Stock.Week
ORDER BY Stock.Week DESC;

SELECT WkPgQuery.ProductGroup, WkPgQuery.Weeek, IIF(IsNull(SUM(ValueQuery.ResultValue)),0,SUM(ValueQuery.ResultValue)) AS ResultValue
FROM (SELECT PGQuery.ProductGroup, WkQuery2.Weeek
FROM(SELECT S.[Product group] AS ProductGroup FROM Stock AS S GROUP BY S.[Product group]) AS PGQuery, 
(SELECT TOP 3 Stock.Weeek AS Weeek FROM Stock GROUP BY Stock.Weeek ORDER BY Stock.Weeek DESC) AS WkQuery2)  AS WkPgQuery LEFT JOIN (SELECT ValueQueryInner.ProductGroup, ValueQueryInner.Weeek, ValueQueryInner.StockDaysRangeShort, ValueQueryInner.EntityCode, ValueQueryInner.ResultValue
FROM (SELECT Stock.[Product group] AS ProductGroup, Stock.Weeek, Stock.StockDaysRangeShort, Stock.[Entity code] AS EntityCode, SUM(Stock.ResultValue) AS ResultValue
FROM Stock WHERE (Stock.StockDaysRangeShort IN (SELECT SAM_Age_Selection.Age AS Age FROM SAM_Age_Selection) AND Stock.[Entity code] IN (SELECT SAM_Entities_Selection.[Entity code] AS TargetEntity FROM SAM_Entities_Selection))
GROUP BY Stock.[Product group], Stock.Weeek, Stock.StockDaysRangeShort, Stock.[Entity code]) AS ValueQueryInner)  AS ValueQuery ON (ValueQuery.ProductGroup = WkPgQuery.ProductGroup) AND (ValueQuery.Weeek = WkPgQuery.Weeek)
GROUP BY WkPgQuery.ProductGroup, WkPgQuery.Weeek;