How to get total value?
Hi there. This is my problem - there is a table with project names, tasks and time (for simplicity there is only 1 project). Each project may have different tasks, and each tasks will take different time to complete. There is also an entry "total" which has to be the sum of time of all tasks for every single project. Project and tasks are entries from one table, and time from another - in that another table there is no entry "total", only tasks, and i can't add it, that's why i need to sum it here somehow, which i can't do, that why i'll be glad if you'll help me. I guess that to complete it we need to create another column (or measure), with condition that if task = "total" then we need to sum all time for each project, and if not we just need to take time without changing. In the end it should be like this:
