On the Layout & Format tab, add a check mark to “For empty cells show:”.Right-click a pivot table cell, and click PivotTable Options.If you’d like to see a zero there, you can change a pivot table setting. Add a check mark in the ‘Show items with no data’ box.Īfter you’ve changed that setting, all the products are listed under each customer name, showing the number of units sold.įor the products that a customer hasn’t bought, the Units column shows a blank cell.In the Field Settings window, click on the Layout & Print tab.Right-click an item in the pivot table field, and click Field Settings.If you’d like to see each product listed for each customer, you can change a setting for the product field. In the pivot table shown above, some items have bought several different products, and some customers only bought one type of product. For example, if you put Customers and Products in the Row area, it only lists the items that each customer has bought. When you create a pivot table from your source data, it only shows the items that have data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |