| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Summaries
Hello,
I have created a pivottable to summarize production data for a two shift 6 day/week operation. I want to summarize Week-to-date and Month-to-date. I set up days as rows and shifts as columns. Days that have no data show up as errors due to division (as in by 0 hours). The table calculates daily subtotals, and subtotals for each shift, but for some reasons, it gives an error for the grand totals. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pivot table created from another pivot table | Excel Worksheet Functions | |||
| Change Data In Pivot Table | New Users to Excel | |||
| Pivot Table - Multiple consolidation Range | Excel Worksheet Functions | |||
| Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
| Pivot Table Problems | Excel Discussion (Misc queries) | |||
Threaded Mode
