Given the following example table below, how can I calculate the growth or decline at the manager level dynamically using a dashboard calculated field? Also, How can I display the results in a dashboard KPI?

To calculate the Growth or decline I need to use the following formula:

and here is an example of how I solved the problem the problem on e-paper :

Based on my paper solution, I then tried to replicate the logic in QuickSight using the sumOver() function and parameters ( start_date / end_date, manager).

Max,
Thanks for taking the time to help me with this issue.
Yes, the start and end dates are parameters. Here is a screenshot of the QuickSight Calculated fields pane.

Hi @ROBERT_J_ESTEVES - I think you are on the right track, but instead of using sumOver, you can just use Sum. sumOver actually results in a non-aggregate field, so when you do your comparisons to build your ratio, that is happening at a row level, and there arent values for two different periods on the same row, which is why you are prob getting nulls.

if you are indeed defining your start and end periods as single days (based on your two parameters), then do these 3 calcs:
Sales-Start: ifelse(date=${startParam}, sales, 0)
Sales-End: ifelse(date=${endParam}, sales, 0)
%Diff: (sum(Sales-End) - sum(Sales-Start) )/ sum(Sales-Start)