Grouping month year and group summarize (total amount)

I couldn't figure out what I do wrong.
grouping expenses by month-year works but when I want to show summarize on each month, sum is wrong

Here is my Code
---
Tables\Columns\TextColumn::make('amount')
  ->label('Amount')
  ->money('EUR')
  ->sortable()
  ->summarize(
      Tables\Columns\Summarizers\Sum::make()->label('Total')->money('EUR', divideBy: 100)
  ),
---
->groups([
    Group::make('date')
        ->getTitleFromRecordUsing(
            fn(Expense $record): string => Carbon::parse($record->date)->format('F Y')
        )
        ->orderQueryUsing(
            fn(Builder $query, string $direction) => $query->orderBy('date', $direction)
        )
        ->titlePrefixedWithLabel(false)
        ->collapsible(), 
])
Screenshot_2025-03-02_at_16.18.52.png
Was this page helpful?