Hello,
I am trying to configure a table with count per month and I am struggling...
I have different types of projects. Each of them have to go through different gates for the project to be completed. I want to have a table which shows how many gates have been passed on that specific month per project type.
Example:
| Type of project | gate 1 | gate 2 | gate 3 | gate 4 |
type 1 | jan 2023 | jan 2023 | march 2023 | |
| type 1 | jan 2023 | feb 2023 | | |
| type 2 | jan 2023 | march 2023 | march 2023 | |
| type 3 | feb 2023 | feb 2023 | march 2023 | march 2023 |
What I want is this:
| | jan 2023 | feb 2023 | mar 2023 |
| gate 1 | 2 | 1 | 0 |
| gate 2 | 1 | 2 | 1 |
| gate 3 | 0 | 0 | 3 |
| gate 4 | 0 | 0 | 1 |
is this doable?
Thank you!
