All,
Little stuck
How do I group up/ sum the following lines by Project number. SO I have only 1 line each for each unique Project No ?
I want to then import this into Power BI
Screenshot-2021-03-04-111824.png
Project No. Stage Current Authority AFC Approved Stages AFC All Stages COWD Project to Date Period Actual
153401 GRIP6 56980000 56980302.28 56980302.28 53681262.81 855395
153401 GRIP6 299.28 0 0 0 0
153401 GRIP6 1769000 1769000 1769000 1300000 0
153406 GRIP7 435000 400674.07 400674.07 400674.07 0
153406 GRIP7 0 -4599.27 -4599.27 -4599.27 0
153406 GRIP7 0 0 0 0 0
153423 GRIP7 0 0 0 0 0
153423 GRIP7 49000 49000 49000 49000 0
153423 GRIP7 17000 16983.35 16983.35 16983.35 0
Bookmarks