Order.objects.select_related('account_customer').all() .values('customer_id', 'other_field_1', ...) .annotate(total_sales=Sum('total_price')) .filter(created_at__year=today.year, created_at__month=today.month)