Summarize table without summarizing groups
Hello everyone,
I would like summaries at the bottom of my table, but not inline with each group. Is it possible to switch of the summaries for the group rows and show just one summary at the bottom of the table?
I would like summaries at the bottom of my table, but not inline with each group. Is it possible to switch of the summaries for the group rows and show just one summary at the bottom of the table?
return $table
->recordTitleAttribute(fn (JournalEntry $journalEntry): string => $journalEntry->commonDescription?->description ?: $journalEntry->description)
->modifyQueryUsing(fn (Builder $query) => $query->with('commonDescription', 'taxAccount'))
->defaultGroup('taxAccount.name')
->groups([
Group::make('taxAccount.name')
->getTitleFromRecordUsing(fn (JournalEntry $record): string => "[{$record->taxAccount->code}] {$record->taxAccount->name}"),
])
->columns([
Tables\Columns\TextColumn::make('description')
->state(fn (JournalEntry $journalEntry): string => $journalEntry->commonDescription?->description ?: $journalEntry->description),
Tables\Columns\TextColumn::make('debit')
->money('GBP')
->summarize(Sum::make()->money('GBP')),
Tables\Columns\TextColumn::make('credit')
->money('GBP')
->summarize(Sum::make()->money('GBP')),
])
->filters([
//
])
->headerActions([
Tables\Actions\CreateAction::make(),
])
->actions([
Tables\Actions\EditAction::make(),
Tables\Actions\DeleteAction::make(),
])
->bulkActions([
Tables\Actions\BulkActionGroup::make([
Tables\Actions\DeleteBulkAction::make(),
]),
]);return $table
->recordTitleAttribute(fn (JournalEntry $journalEntry): string => $journalEntry->commonDescription?->description ?: $journalEntry->description)
->modifyQueryUsing(fn (Builder $query) => $query->with('commonDescription', 'taxAccount'))
->defaultGroup('taxAccount.name')
->groups([
Group::make('taxAccount.name')
->getTitleFromRecordUsing(fn (JournalEntry $record): string => "[{$record->taxAccount->code}] {$record->taxAccount->name}"),
])
->columns([
Tables\Columns\TextColumn::make('description')
->state(fn (JournalEntry $journalEntry): string => $journalEntry->commonDescription?->description ?: $journalEntry->description),
Tables\Columns\TextColumn::make('debit')
->money('GBP')
->summarize(Sum::make()->money('GBP')),
Tables\Columns\TextColumn::make('credit')
->money('GBP')
->summarize(Sum::make()->money('GBP')),
])
->filters([
//
])
->headerActions([
Tables\Actions\CreateAction::make(),
])
->actions([
Tables\Actions\EditAction::make(),
Tables\Actions\DeleteAction::make(),
])
->bulkActions([
Tables\Actions\BulkActionGroup::make([
Tables\Actions\DeleteBulkAction::make(),
]),
]);