Hi - hope you can help me here.
I have 4 worksheets (N,S,E,W), each with an identical table that contains 2 columns: Column 1 "Description", Column 2 "Qty"
On the 5th worksheet I want to create a pivot table that I can have one list of descriptions on the x-axis, and then combine the qty's from tables from the other sheets.
The goal is to allow the user to make modifications to the N,S,E,W tables, and use the pivot table to manipulate the data.
I have created the proper tables (with names) - the pivot table was created to use data from all of the tables.
What I can't quite figure out is on the pivot chart, when I select the qty field to report for the second table, and then try to add it to the pivot chart, it does not combine the totals and it prompts me that relationships may need to be created.
I am not sure how to configure the relationships. I know one other option could be to combine the 4 tables into a single table, add a new column that is the N,S,E,W and then group by that column so it is similar but I was hoping I could do it through the pivot charts.
excel_test.jpg
(not sure if the attachment worked)
Any thoughts? (Or did I explain this clear enough?)
Bookmarks