How to achieve this output

[surajseshan]

I have this input below

Input screen shot

i need the desired output

Output screen shot - 

Note :- Budgeted hours (new column) to be fixed at 250 hours for each month

Actual hours should be sum of charged hours on each month

Month - group by month and year in the same format as given in output screenshot

[ShankerV · Accepted solution]

Hi @surajseshan 

Months added in the output, the workflow generates the output dynamically for other months too.

Output:

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @surajseshan 

++One more information

In the step5, 

Change this 250 to any value in future if you need to change.

Many thanks

Shanker V

[surajseshan]

If the date format is different please advise how to proceed

[ShankerV · Accepted solution]

Hi @surajseshan 

I assume the date might be in alteryx format 2022-07-30

Then use, 

right(Left([Field1],7),2)+"-"+right(Left([Field1],4),2)

this will help!!!!

[surajseshan]

Hi Shanker - Thank you for the solution..it really works in my main file .. Thank you for the support ..