Need to update some values when the search filter is applied.

csajit

Here is my example table.

Artist | Service | Cash | Credit | Expense | Date | Description

A | Services | 400 | 200 | 100 | 09/29/2014 | user test.
jonn | test | 100 | 0 | 0 | 09/29/2014 | sample sale
Steve | tattoo | 100 | 0 | 0 | 09/30/2014 | mermaid
Steve | piercing | 0 | 50 | 0 | 09/30/2014 | Nose

Showing 1 to 4 of 4 entries

Total Cash: $600
Total Credit: $250
Total: $750

WHEN the search filter(Steve) is applied,Total Cash, Credit, Total should get calculated once again. How can we do this?

Artist | Service | Cash | Credit | Expense | Date | Description

Steve | tattoo | 100 | 0 | 0 | 09/30/2014 | mermaid
Steve | piercing | 0 | 50 | 0 | 09/30/2014 | Nose

Showing 1 to 2 of 2 entries (filtered from 4 total entries)

Total Cash: $600
Total Credit: $250
Total: $750

Please let me know how to implement this.

Thanks,
AK