No<\/strong> in a PivotTable.<\/p>\n\n\n\nHow to show Yes and No in a PivotTable<\/h2>\n\n\n\n We use the following PivotTable<\/strong> in our illustration. We will show Yes<\/strong> in the cells that contain sale amounts and No<\/strong> in the cells that have no values. This is done in two steps.<\/p>\n\n\n\n <\/figure>\n\n\n\nStep 1: Display zeroes in the empty cells<\/h3>\n\n\n\n We first need to change the settings of the PivotTable such that zeroes are displayed in the empty cells.<\/p>\n\n\n\n
We use the steps below:<\/p>\n\n\n\n
\nClick PivotTable Analyze >> PivotTable >> Options Arrow >> Options. <\/strong>This opens the PivotTable Options<\/strong> dialog box.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\n\nIn the PivotTable Options<\/strong> dialog box that appears, ensure that the For empty cells show<\/strong> checkbox is checked. Then type 0 (zero) in the box next to it and click OK<\/strong>.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\nZeros are displayed in the once empty cells:<\/p>\n\n\n\n <\/figure>\n\n\n\nStep 2: Create a custom number format that displays Yes or No in the data cells<\/h3>\n\n\n\n We create a custom number format that displays Yes<\/strong> for positive sale amounts and No<\/strong> for 0 (zero) values.<\/p>\n\n\n\nWe use the following steps:<\/p>\n\n\n\n
\nRight-click any data cell in the PivotTable and choose Value Field Settings<\/strong> from the shortcut menu.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\n\nClick the Number Format<\/strong> button in the Value Field Settings<\/strong> dialog box.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\n\nIn the Format Cells<\/strong> dialog box that appears, select Custom<\/strong> in the Category<\/strong> list box.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\n\nSelect and delete the number format displayed in the Type<\/strong> box on the right. Then type in the following custom number format and click OK<\/strong>:<\/li>\n<\/ol>\n\n\n\n“Yes”;;”No”<\/p>\n\n\n\n <\/figure>\n\n\n\nNote<\/strong>: What this number format is telling Excel is, \u201cShow Yes for positive values, show nothing for negative values, and show No for zero values.\u201d<\/p>\n\n\n\n\nClick the OK<\/strong> button in the Value Field Settings<\/strong> dialog box.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\nYes and No values are now displayed in the PivotTable.<\/p>\n\n\n\n
Conclusion<\/h2>\n\n\n\n We can show Yes<\/strong> and No<\/strong> in a PivotTable by first displaying 0s (zeros) in empty data cells. We then create a custom number format that displays Yes <\/strong>for positive values and No<\/strong> for 0 (zero) values.<\/p>\n","protected":false},"excerpt":{"rendered":"Sometimes we may want to show Yes or No in a PivotTable instead of other values. This tutorial shows you how to show…<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[170,190],"yoast_head":"\n
Show Yes No in a PivotTable<\/title>\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\t \n\t \n\t \n