is it possible to combine multiple spread sheets into one pivot table to get an average for selected spread sheets
MacBook Pro 13″, macOS 13.3
A spreadsheet in Numbers means a document. Do you mean table?
A Pivot Table is based on a single Table.
If you can give more details on your document it will be easier to suggest how you can achieve your goals.
SG
No, a Pivot Table is based on one table.
Am curious, why do you need so many different documents?
SG
Yes 5 spreadsheets (documents) M-F. and 5 Pivot tables also M-F to give daily average. Would like to create another table to see weekly average. I suppose one way to do that is to create another document for the week, then create another pivot table of that document. I could not find anything in the manual, to create a table to track across multiple Documents.
Not a brick and mortar. I am on the road, and I have 10 separate days I track. I track multiple items, such as sales, units, bc, etc. I track them by 3 hour increments, so as I can compare progress to previous same days progress. Using iPhone to do this. I see now that I need to create one document to do all of this, would make life so much simpler. 😔
combine multiple spread sheets into one pivot table
