Custom summaries with value calculated in column

I'm encountering an issue with a dynamic column in Filament that calculates a price on the fly and needs to display a summarized total at the bottom of the table. The column does not store data in the database but computes it dynamically within the column definition. The problem arises because the calculation seems to be performed multiple times, resulting in an incorrect total.