ExcelBanter - how do i only see subtotals in a pivot and hide the detail

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how do i only see subtotals in a pivot and hide the detail (https://www.excelbanter.com/excel-worksheet-functions/52483-how-do-i-only-see-subtotals-pivot-hide-detail.html)

GGG

how do i only see subtotals in a pivot and hide the detail

Arvi Laanemets

how do i only see subtotals in a pivot and hide the detail

Hi

Right-click on returned table, ans select Table Options
Uncheck both Grand Totals for Rows and Grand Totals for Columns

--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )

"GGG" wrote in message
...

All times are GMT +1. The time now is 09:52 PM.