Pulling filter data into a cell?

I am filtering data pertaining to part numbers, quantities and prices on a spreadsheet. I would like to filter only one specific customer to see what they are buying.

Then I would like to have a cell that reads "Total dollar value for <customer name>" and the name displayed will match the data that the filtered column still shows.

For example, if I have customers A, B and C and I want to see ONLY customer B's activity, I would filter the "Customer" column so that only customer B is shown. Then I want the cell below the data set to read "Total dollar value for B".

I could try doing this with simple cell references and concatenation (e.g. CONCATENATE("Total dollar value for ),D5)) but I don't know how to make that work with a filtered table that will have a varying row count.

Any ideas? I can try to post a simple example later, all I have right now is my actual data set and it is sensitive information so I don't want to post it.

The Subtotal function will return results based on unhidden rows only; see Help.

And as a matter of good practice and simplicity, the total should appear ABOVE the filtered data.