Hi,
I have a table like the one below.
I am trying to build a matrix where I have the maximum stage reached and the current stage, something like this
And all of this I would like to have it dynamically changing having a filter saying Jan 2022, Feb 2022, Mar 2022,.... Where I can select the month and I get the figures updated.
Is it possible? And could you help with the formulas?
I have a table like the one below.
| User | Current Stage | Stage 1 Date | Stage 2 Date | Stage 3 Date | |
| A | Stage 2 | 15/2/2022 | 16/4/2022 | ||
| B | Stage 1 | 10/1/2022 | |||
| C | Stage 3 | 22/5/2022 | 26/6/2022 | 28/6/2022 | |
| D | Stage 1 | 14/4/2022 | 16/4/2022 | ||
| E | Stage 2 | 15/1/2022 | 16/2/2022 | 18/4/2022 |
| Current Value Stage 1 | Current Value Stage 2 | Current Value Stage 3 | |
| Reached Max stage 1 | 1 | ||
| Reached Max stage 2 | 1 | 2 | |
| Reached Max stage 3 | 1 | 1 |
And all of this I would like to have it dynamically changing having a filter saying Jan 2022, Feb 2022, Mar 2022,.... Where I can select the month and I get the figures updated.
Is it possible? And could you help with the formulas?
