Issues with OpenSearch Dashboard Aggregations

Hello, I am creating a visualization that sums the monetary amount on the ex_sheet_line table and groups it by employee to calculate total employee spend. Essentially, I'm trying to find the top 10 employee spend regardless of line and sheet status. The dashboard is showing a total of $52,775.58 for employee x when viewing the tile, but when I drill down on that employee by clicking on the individuals bar, the value changes to $53,416.28. The correct sum of the monetary amount for the employee is $53,416.28, as validated in the my environment in PL/SQL. Does anyone know why the