Not able to save CTE as Table or View

Hello lovishsood1 
When you say "I want to save this SCRIPT as TABLE "  , I am asuming that the intend is just to have these rows on some report , please correct me if I am wrong . I think we can use the view route for this for now.

Since you have a CTE which you are running and i suggest you can create a view using the the CTE ( AndyDDC  was also pointing that out ) and the use that view to get the data in the report . I have some dummy data with which i tried and it worked . 

Create TABLE TimelogByType

(Month_Name varchar(100) ,Month_Number int ,Project_Category varchar(100) , Actual_Hours int  )

 

 

INSERT INTO TimelogByType values ('Jan',202301,'AAA',8)

INSERT INTO TimelogByType values ('Jan',202301,'AAA',18)

INSERT INTO TimelogByType values ('Feb',202302,'BBB',118)

INSERT INTO TimelogByType values ('Feb',202302,'CCC',1118)

 

CREATE view dbo.vwGetData

As

WITH cte as

(

SELECT

        Month_Name,

        Month_Number,

        Project_Category,

       

        100.0 * Actual_Hours / NULLIF(SUM(Actual_Hours) OVER (PARTITION BY Month_Name, Month_Number), 0) AS Percentage

    FROM

        [dbo].[TimelogByType]

        )

        select cte.Month_Name,

        cte.Month_Number,

        cte.Project_Category,Sum(cte.Percentage) AS Percentage from cte GROUP by cte.Month_Name,cte.Month_Number,cte.Project_Category;

 

select * from dbo.vwGetData

 

 

 You can also call this a inn powerBI report as this . 

 

 let me know if you have any question .

Thanks 
Himanshu