Filtered aggregates are used to include only some rows into the aggregation
select customer_id, sum(amount) as total_amount, sum(amount) filter (where amount > 10000) as large_orders_amount from customers group by customer_id;
This can be re-written as
select customer_id, sum(amount) as total_amount, sum(case when amount > 10000 then amount end) as large_orders_amount from customers group by customer_id;