Hi @llan,
When building calculated fields in QuickSight, it’s more about utilizing field names instead of columns and making sure to utilize the correct function. Here’s a great article that lists out the QuickSight functions by category:
In regards to the calculation you’re trying to perform, I would suggest utilizing a sum or sumOver function depending on how you’d like to aggregate.
Additionally, here’s one more article that really helped me understand different use cases on using level aware calculations:
Let us know if you have any additional questions