How can i do a Sum Row

[BenOussama180]

how can i achieve something like this using this package :

making a sum row that would sum all the columns numbers

[lrljoe]

See guidance here on Footers
https://rappasoft.com/docs/laravel-livewire-tables/v2/columns/footer

i.e.

Column::make('Price')
    ->sortable()
    ->footer(function($rows) {
        return 'Subtotal: ' . $rows->sum('price');
    }),

[BenOussama180]

it does not work in my case since my column is a label like this :

Column::make("Expenses", "expenses")
                ->label(fn ($row) => $fmt->formatCurrency($row->linksOrders->sum('price'), "EUR"))
                ->sortable()
                ->footer(function ($rows) {
                    return 'SubTotal : ' . $rows->sum('price');
                }),

soo it shows 0 :

[lrljoe]

For your Column.

I'd suggest using withSum() in your Builder function to include just the sum of your linksOrders, to avoid having to do multiple sum functions.
You can then reference the sum in your footer() more easily.

E.g. your builder will have the following

 ->withSum('linksOrders', 'price')

You can then reference a new sum field instead of having to do $row->linksOrders->sum('price')

[BenOussama180]

i tried your way :

public function builder(): Builder
    {
        return Project::query()
            ->forAuthCustomer()
            ->whereArchived(0)
            ->with(['linksOrders'])
            ->withSum('linksOrders', 'price')
            ->withSum([
                'linksOrders as links_orders_sum_price_live' => fn ($query) => $query->whereIn('orders.status', [Order::COMPLETED, Order::PUBLISHED]),
            ], 'price')
            ->withSum([
                'linksOrders as links_orders_sum_price_progress' => fn ($query) => $query->whereIn('orders.status', [Order::PROCESSING, Order::WAITING_ARTICLE, Order::WAITING_CONFIRMATION, Order::PENDING]),
            ], 'price')
            ->withSum([
                'linksOrders as links_orders_sum_price_attention' => fn ($query) => $query->whereIn('orders.status', [Order::ARTICLE_READY, Order::PRICE_CHANGED, Order::PAUSE]),
            ], 'price')
            ->withSum([
                'linksOrders as links_orders_sum_price_canceled' => fn ($query) => $query->whereIn('orders.status', [Order::CANCELED, Order::REJECTED]),
            ], 'price');
    }

Column::make("Expenses", "expenses")
                ->label(fn ($row) => $fmt->formatCurrency($row->links_orders_sum_price, "EUR"))
                ->sortable()
                ->footer(function ($rows) {
                    return $rows->sum('price');
                }),

            Column::make("Live", "live")
                ->label(fn ($row) => $fmt->formatCurrency($row->links_orders_sum_price_live, "EUR"))
                ->sortable()
                ->footer(function ($rows) {
                    return $rows->sum('price');
                }),

            Column::make("In Progress", "in_progress")
                ->label(fn ($row) => $fmt->formatCurrency($row->links_orders_sum_price_progress, "EUR"))
                ->sortable()
                ->footer(function ($rows) {
                    return $rows->sum('price');
                }),

            Column::make("Needs Attention", "needs_attention")
                ->label(fn ($row) => $fmt->formatCurrency($row->links_orders_sum_price_attention, "EUR"))
                ->sortable()
                ->footer(function ($rows) {
                    return $rows->sum('price');
                }),

            Column::make("Canceled")
                ->label(fn ($row) => $fmt->formatCurrency($row->links_orders_sum_price_canceled, "EUR"))
                ->sortable()
                ->footer(function ($rows) {
                    return $rows->sum('price');
                }),

still showing 0 :

[lrljoe]

You'll need to pass the correct field to the footer. For example

            Column::make("In Progress", "in_progress")
                ->label(fn ($row) => $fmt->formatCurrency($row->links_orders_sum_price_progress, "EUR"))
                ->sortable()
                ->footer(function ($rows) {
                    return $rows->sum('links_orders_sum_price_progress');
                }),

[BenOussama180]

thanks alot ! it works !!