I have a table with invoice no., names and totals on every row. I am looking for a way to produce a bar graph where I can compare invoices that have all names that I can select. For example.
InvNo.1 - Bob - 10
InvNo.1 - Fred - 15
InvNo.2 - Bob - 5
InvNo.2 - Fred - 10
InvNo.2 - Tom - 20
I was hoping to be able to select Bob, Fred and Tom and only return the totals where all 3 of those names appear for the same invoice. So it wouldn't return individual totals for InvNo.1 only InvNo.2. And if I selected Bob and Fred it would only return InvNo.1 and ignore the invoice with Tom. Is this possible? Would a pivot table be better suited for this and if so, how should I go about it. Thanks for any help.
Bookmarks