How to filter by sum of two columns in gridview?

Question

Yii

It is necessary that the GridView filter by the sum of two values. I display in GridView

[
                'attribute' => 'sum_goods',
                'label' => 'Сумма за товар',
                'value' => function ($model) {
                    return number_format($model->sum_goods + $model->sum_user_transport, 2, '.', ' ');
                }
            ],

How to set up a filter?
Tried to add conditions andWhere - does not help

Answer 1

not in this implementation. Yii2 sorts at the SQL level. Accordingly, for sorting, you need to form the specified field using aggregate functions in the request for obtaining data, and only then sort by it