I’ll do my best to explain what I’m trying to achieve.
I have two tables:
- Task table: Includes a list of unique tasks carried out for my project
- Time log table: This includes time log entries for each of the unique tasks. There can be multiple time log entries for a single task, each with its own unique time stamp.
What I want to do is create a summary table that lets me know how much time was spent per task, on a given month, without showing the detail of the time logs.
I’ve created this document with a basic example of how the data is setup and the expected result as a Summary Table.
Any help or ways to this differently are greatly appreciated!