ExcelBanter - Hide data in pivot table

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Hide data in pivot table (https://www.excelbanter.com/excel-discussion-misc-queries/129348-hide-data-pivot-table.html)

Rik

Hide data in pivot table

Is it possible to hide all data in a pivot and only show subtotals?
--
Rik van Andel
Netherlands

Jim Thomlinson

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

All times are GMT +1. The time now is 05:37 PM.