Hi @GuiFox
The high-level steps involve, creating multiple variables with the correct order of evaluation. Here is a good example - click here). Then, perform the calculations based on this video.
Click here - full list of Pre-built functions.
In case you need further assistance with your problem, please create a sample dashboard with sample dataset showing your problem state using Arena and post it here. (Details on using Arena can be found here - QuickSight Arena
Alex