If you create a simple new pivot table, select "add this data to the Data Model") too, is the option for "show items with no data" greyed out via Field settings>Layout & print option?ģ.Please share a full screenshot of Product Information in Excelįile> Account, we 'd like check if we can reproduce the same behavior.
To better understand the situation, could you please help to confirm the following information?ġ.Regarding "I have selected the pivot table options to "show items with no data" in columns and rows",ĭo you right click the pivot table and select PivotTable Options>inĭisplay tab, check "Show items with no data on rows" and "Show items with no data on columns"?Ģ.1)Please share a screenshot about the issue symptom from your side.Ģ)You mentioned "When creating my pivot table I am selecting "add this data to the data model". Thanks for sharing your experience with us.
0 kommentar(er)
