| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Suppress sub totals on pivot table
I am using Excel 2002. Here is a sample spreadsheet : Bill $1 Bill $3 Bob $5 Bob $5 Jerry $6 If I do a pivot table on the above data. I will get a subtotal on each person. I do not want subtotals. I only want the grand totals. How can I suppress the subtotals on a pivot table? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Suppress Zeros in a Pivot Table | Excel Discussion (Misc queries) | |||
| Pivot Table Sub-Totals | Excel Worksheet Functions | |||
| Pivot Table Chart - With Pivot Table Totals | Charts and Charting in Excel | |||
| Pivot Table -- Suppress blank cells | Excel Discussion (Misc queries) | |||
| Pivot table totals | Excel Discussion (Misc queries) | |||
Threaded Mode
