| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide data in pivot table
Is it possible to hide all data in a pivot and only show subtotals?
-- Rik van Andel Netherlands |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hide data in pivot table
Just put the item you want subtotaled in the middle of the pivot table. Now
add the other dimension to the rows and columns to reneder the appropriate subtotals. Not too sure what you wnat to hide as that will show the appropriate aggregations with no more or less detail than you have placed in the rows and columns. -- HTH... Jim Thomlinson "Rik" wrote: Is it possible to hide all data in a pivot and only show subtotals? -- Rik van Andel Netherlands |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table - Use Other Pivot Table as Data Source | Excel Discussion (Misc queries) | |||
| How do I sort pivot table data outside a pivot table | Excel Worksheet Functions | |||
| Count only if another column has data in Pivot Table? | Excel Worksheet Functions | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Change Data In Pivot Table | New Users to Excel | |||
Linear Mode
