ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to stop subtotals in Pivot Tbl (https://www.excelbanter.com/excel-discussion-misc-queries/100682-how-stop-subtotals-pivot-tbl.html)

dpenny

how to stop subtotals in Pivot Tbl
 

I just searched thes forums on how to turn off subtotals when
row/columns categories more than 1.

I found the following - does not work for me.
=======
You can deactivate the row subtotals going to the field settings
(double
click on the header, for example), and selecting none in the subtotals
section.
Hope this helps,
Miguel.
=======

Any ideas?

DickPenny


--
dpenny
------------------------------------------------------------------------
dpenny's Profile: http://www.excelforum.com/member.php...o&userid=19708
View this thread: http://www.excelforum.com/showthread...hreadid=563903


dpenny

how to stop subtotals in Pivot Tbl
 

I must be blind, it was right in front of me.

Thanx.


--
dpenny
------------------------------------------------------------------------
dpenny's Profile: http://www.excelforum.com/member.php...o&userid=19708
View this thread: http://www.excelforum.com/showthread...hreadid=563903



All times are GMT +1. The time now is 11:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com