@foreach ($billGenerates->groupBy('client_id') as $clientId => $bills) @php $latestBill = $bills->last(); @endphp @endforeach

ID	User ID	User Name	User Contact No	POP	Total Bill	Total Paid	Total Due
{{ $latestBill->clients->id }}	{{ $latestBill->clients->userid }}	{{ $latestBill->clientsinfo->clients_name }}	{{ $latestBill->clientsinfo->contact_no }}	{{ $latestBill->clients->pops->popname }}	{{ $bills->sum('bill_amount') }}	{{ $bills->sum('paid_amount') }}	{{ $bills->sum('bill_amount') - $bills->sum('paid_amount') }}
Sum					{{ $billGenerates->sum('bill_amount') }}	{{ $billGenerates->sum('paid_amount') }}	{{ $billGenerates->sum('bill_amount') - $billGenerates->sum('paid_amount') }}