Query to compute unspecified values in "Other" category
The following query would accomplish what you're looking for:
SELECT name, category, percentage
FROM expense_profile
WHERE name = 'Bob'

UNION ALL

SELECT name, 'Other' AS category, 100.0 - SUM(percentage) AS percentage
FROM expense_profile
WHERE name = 'Bob'
GROUP BY name