SELECT 
	ISNULL(Product_Name,'ZProductTotal') as Product_name,
	ISNULL(Scheme_Name,'ZTotal') as Scheme_Name,
	SUM(Invest_Amount) AS [Invest_Amount], 
	SUM(broker_commission) AS [Broker_Commission],
	GROUPING(Scheme_Name) AS [IsSchemeTotal],
	GROUPING(Product_Name) AS [IsGrandTotal]
FROM @GroupTest
GROUP BY Product_Name,Scheme_Name
WITH ROLLUP
ORDER BY Product_Name,Scheme_Name, IsSchemeTotal, IsGrandTotal

ORDER BY IsGrandTotal, Product_Name, IsSchemeTotal, Scheme_Name

SELECT 
Product_Name,
Scheme_Name,
Invest_Amount, 
broker_commission,
-1 AS IsSchemeTotal,
-1 as IsGrandTotal
FROM @GroupTest
Union ALL
select  
isnull(Product_Name, 'ZProductTotal'),
isnull(Scheme_Name,'ZTotal'), 
sum(Invest_Amount),
SUM(Broker_Commission),
GROUPING(Scheme_Name) AS IsSchemeTotal,
GROUPING(Product_Name) AS IsGrandTotal
from @grouptest
group by rollup (Product_Name,Scheme_Name)
ORDER BY Product_Name,
Scheme_Name,
IsSchemeTotal,
IsGrandTotal

SELECT Product_Name,
Scheme_Name,
Invest_Amount, 
broker_commission,
-1 AS GrandTotal,
-1 as ProductTotal     --<=== Added this
FROM @GroupTest
	UNION ALL
SELECT ISNULL(Product_Name,'ZProductTotal'),
ISNULL(Scheme_Name,
'ZTotal'),
SUM(Invest_Amount) AS 'Invest_Amount',
 SUM(broker_commission) AS 'Broker_Commission',
GROUPING(Product_Name)'GrandTotal',
GROUPING(Scheme_Name)'ProductTotal'  --<==== added this
FROM @GroupTest
GROUP BY Product_Name,
Scheme_Name
WITH ROLLUP
ORDER BY Product_Name,
Scheme_Name,
 GrandTotal