I am an Excel novice (never used it for anything more than high school science class), so pardon me if I don't know the correct terminology. My question is twofold:
1. I am trying to create a pivot table that draws data from multiple sources. When I create a table from data from a single sheet, I get far more options as far as organizing the table and viewing the data (see "What I want Master to look like" sheet. However, when I choose to create a table from multiple consolidation ranges, I lose those options (eg I can't make the table add the costs column up to get a total without it also adding the date column).
Is there a way to do achieve the same type of table when using data off different sheets? I don't want to have to copy and paste the data into one sheet every time I want to generate the table.
2. Figured out this question.
Sample document attached. Thanks for any help.
Bookmarks