Forum Discussion
Monthly Project Income Summary with weekly detailed overview
Hello Ibendlin,
Thank you for your response.
Below you can find more sample data: (I've also put it in a table so it's easyer copy/pastable)
| Date | WeekNumber | Month | ProjectName | Employee | WorkingType | Hours spent | Calculated Income |
| 01/01/2020 | 1 | January | Project1 | John Doe | PM | 1 | 60 |
| 08/01/2020 | 2 | January | Project1 | John Doe | PM | 1 | 60 |
| 01/01/2020 | 1 | January | Project1 | Jane Doe | PE | 4 | 50 |
| 08/01/2020 | 2 | January | Project1 | Jane Doe | PE | 4 | 50 |
| 01/02/2020 | 5 | February | Project1 | John Doe | PM | 2 | 120 |
| 08/02/2020 | 6 | February | Project1 | Jane Doe | PE | 4 | 50 |
| 08/02/2020 | 6 | February | Project1 | John Doe | PM | 1 | 60 |
| 15/02/2020 | 7 | February | Project1 | Jane Doe | PE | 4 | 50 |
To respond to your question if I have a proper calendar table with all relevant fiscal colums, at the moment I do not, but I suspect your question is suggestive so I will look deeper into this to add this to the report.
As for an expected outcome across multiple months, the desired result should have a result more based on the differentiation between PM & PE. This graph can be seen as below previewed, and I have also updated the mock (weekly view) to the updated data:
1. Updated Weekly Mock
2. Monthly Income Overview:
I hope this information is sufficient, and if you would have any other suggestions or requirments to respond properly, please let me know and I will respond as good as possible.
Thank you for the effort.