Multiple records if filtering only want to display common occurence

[kac1125]

I have a list of items and a list of clients that order. Some items are ordered by multiple clients. In the table I also have a total orders for all clients. I have used total as the client name for the sum of all orders combined. What I am trying to do is filter the client name to see what items they order, but also want to include total in that filter. The issue is I only want to see common items between the client name and the total. If I filter to Client A and Total I get the items that client A pulls plus the total of all items. What I want is lets say i have 100 item numbers Client A only pulls 15. I want to see those 15 for that client and the total for each of the 15 items. But like I said i get the 15 items for Client A plus the total of all 100 items. Please let me know if there is an easy way to accomplish this..

Thank you in advance

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

It would also be helpful to see some dummy sample data and the expected results with XL2BB so that we know how the data is laid out and how you would expect to see the result(s) presented. At the moment we would just be guessing if we tried to set up a sheet to test what you have and what you want.