ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to hide an item subtotal in the row field? (https://www.excelbanter.com/excel-discussion-misc-queries/123582-how-hide-item-subtotal-row-field.html)

Daniel

How to hide an item subtotal in the row field?
 
To make the appearance of the pivot table report simpler, concise and short,
thereby eliminating repetitive entries, how do I hide an item sub-total on
one of the selected items that was dragged in the row field?

RichardSchollar

How to hide an item subtotal in the row field?
 
Hi Daniel

Do you mean by right-clicking in the row field, going to Field Settings
and selecting "Non" for subtotals?

Best regards

Richard


Daniel wrote:
To make the appearance of the pivot table report simpler, concise and short,
thereby eliminating repetitive entries, how do I hide an item sub-total on
one of the selected items that was dragged in the row field?




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

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