如何禁用删除Excel数据透视表中的小计下的个人计数? [英] How to disable to remove individual count under subtotal in Excel pivot table?

问题描述

我对编程还很陌生，所以我不知道我是否使用了正确的单词，但是我正在为我的图书馆图书清单创建一个数据透视表，并且我想隐藏所有这些1./p>

正如您所看到的，我在小计下的每个书名旁边都有那些1(第一行)的行，我想知道是否有一种方法可以禁用它们，因为它们看上去很分散注意力.非常感谢！！！

解决方案

数据透视表值将始终显示.正如评论中所建议的那样，过滤可能不是您想要的.

您可以使用条件格式来隐藏单个值的1.在屏幕截图中，我正在计算数据的标题"列.选择"1"值之一，然后单击首页"功能区>条件格式">新规则"

单击以箭头突出显示的选项.它将显示您的列名而不是标题".

然后单击使用公式来确定...."，然后输入如下所示的公式:

我选择的单元格是F6，无论您选择什么单元格，都需要进入公式框没有美元符号！

下一步，单击格式"按钮，然后使用白色背景上的白色字体或自定义数字格式 ;;; .

确认所有对话框并享受结果.请注意，由于条件格式仅作用于显示标题"的标题计数"值的单元格(如我的第一个屏幕截图所示)，因此30-Jun的小计"1"并没有消失.

I'm quite new to programming, so I don't know if I am using the right words, BUT I'm creating a pivot table for my list of library books, and I want to hide all those 1s.

As you can see, I have those lines of 1s next each of the book titles under the subtotal, and I was wondering if there was a way to disable them because they look quite distracting. Thanks so much!!!

解决方案

Pivot table values will always show. Filtering, as suggested in a comment, is probably not what you want.

You could use conditional formatting to hide the 1's for the individual values. In the screenshot, I'm counting the "Title" column of the data. Select one of the "1" values, then click Home ribbon > Conditional formatting > New Rule

Click the option highlighted with the arrow. It will show your column name instead of "title".

Then click "Use a formula to determine ...." and enter the formula like below:

My selected cell is F6 and whatever cell you have selected needs to go into the formula box WITHOUT the dollar signs!

Next click the Format button and use either white font on white background, or a custom number format ;;;.

Confirm all the dialogs and enjoy the result. Note how the subtotal "1" for 30-Jun did not disappear, because the conditional format acts only on cells showing "Count of title" values for "Title", as ticked in my first screenshot.

这篇关于如何禁用删除Excel数据透视表中的小计下的个人计数?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！