SQL-SERVER ROLLUP Onhand quantity JD Edwards

Select CASE WHEN (Grouping(CategoryName)=1) THEN 'MainTotal' ELSE categoryname END AS CategoryName, CASE WHEN (Grouping(ProductName)=1) THEN 'SubTotal' ELSE Productname END AS ProductName, Sum(UnitPrice) as unitprice, Sum(UnitsinStock) as UnitsinStock from jde_rk.dbo.Products Products INNER JOIN jde_rk.dbo.Categories Categories On Products.categoryID = Categories.CategoryID Group By Categoryname, ProductName WITh ROLLUP