there's no grand total. The table is grouped by weeks- so there are about 50 totals. I see when I click on one of the weeks that it does open a new sheet with the detail data that I need---but only for that week.
Good idea. Right click within the pivot table and see if you have "table options". Then select "Grand Totals For Columns". Or similar. Back to the PT and double click on grand total. Might be all you need. Fingers crossed!
yeah - it did work! Sort-of... I was able to add the column total. However, when it was creating the detail, it hit the row limit because it gave me an error that "not all data was loaded"---maybe I can split it into several sections.
Hope this makes sense. It might help with grouping on the weeks - to split the data into sub-groups of a manageable size. So the 50 weeks could be grouped into, say, 5 higher-level groups: and then do the double-click trick on each of the five goups.
Excel's row limit is 65,536. You can take it from Excel to Access to overcome Excels' limit.