Forum Discussion
Qweaqwes1500
Feb 12, 2019Copper Contributor
How to add a row in PivotTable which is not included in the data?
Good day. I am a beginner of excel user. I have met a trouble in using Pivot Table. I want to make a report but i found that i can't add a blank row for the category which is not include in the data...
- Feb 12, 2019
Another way, not to add dummy records every time, you may add separate table with list of all your customers, create relationship with your transactions table on customers, and use customers name from the second table creating Pivot Table. When create it, check 'Add data to data model' box. In Pivot Table options, Display tab, check 'Show item with no data on rows' box.
If you have long table of transactions where all customers exist, and you filter Pivot Table on month in which some customers make no transactions, it'll be enough to check 'Show items...'
ClickEnter
Feb 12, 2019Copper Contributor
hi,
try to add this information in your data sheet, for example add a row , client E, jan 0. in your pivot table, right click and press "refresh".
good luck