Totals with Tables themselves

Totals with Tables themselves

I've created a table to monitor service usage of our company.  A client buys a set number of hours of service and then as they use the service, we "debit" the account.

I have a "Hours Purchased" and "Hours Used" column, along with a formula column for "Balance" that subtracts Used from Purchased.  In using a pivot table report, I can obtain totals and grand totals. 

There does not appear to be any way to get totals WITHIN a table.  If there is, that would pretty much solve my problems.  I could filter based on a client's name, then look at the bottom to figure out what their TOTAL BALANCE is with us.

Under the pivot table report, as an administrator, I can Edit Design, then change the filter on the report to pull only what I want.  But the staff I've shared the pivot tables with can't do that.  They can only see the total list of hundreds of clients, then have to scroll down to find the client they're looking for.

Question #1:  Is there ANY way to get totals WITHIN A TABLE ITSELF?

Question #2:  If the answer to #1 is "no" then is there any way for a NON ADMINISTRATOR to be able to filter a pivot table report to find a specific client?

Thank you,