Hi all,
I'm working with two sheets, each has a table on them, each row listing: invoice number; customer name; invoice date; product sold; and sale amount. The separate sheets are from different time periods.
I would like to create a pivot table that consolidates the customer names and gives me total sales for each customer, with varying details underneath.
I don't know a lot about pivot tables, but when I use data from two tables, it shows one table correctly, listing each customer with totals, but if I try to add another table, it simply puts all the customers from other sheet underneath the first entry and so on..
How can I get it to recognize the customer name on each sheet and consolidate them, then show totals? I've tried to create a relationship between tables, however, as each customer is listed multiple times on each sheet, it doesn't work. Thank you so much in advance.
Bookmarks