Forum Discussion
Is it possible to keep all the row items showing in a Pivot Table
Hi all,
Is it possble to keep all pssible the row items showing in the pivot table even when no values in some. So I have 4 items in the row area North South East West BUT if only values in North And West then only North & West show in the pivot table. Is it possible to keep the pivot table showing North South East West all the time (even if no values for some)
thanks for any suggestions
Bert
thanks Wyn late better than never
Wyn Hopkins wrote:Hi Bert, a late response I know
Right click on one of the regions displaying, go to field settings > Layout and Print > Show Items with no data
Better off posting queries here....
https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel?sort=lastreplydate&dir=desc&tab=threads&status=unanswered&mod=&modAge=&advFil=&postedAfter=&postedBefore=&threadType=all&tm=1477994505548&auth=1
3 Replies
Hi Bert, a late response I know
Right click on one of the regions displaying, go to field settings > Layout and Print > Show Items with no data
Better off posting queries here....
thanks Wyn late better than never
Wyn Hopkins wrote:Hi Bert, a late response I know
Right click on one of the regions displaying, go to field settings > Layout and Print > Show Items with no data
Better off posting queries here....
https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel?sort=lastreplydate&dir=desc&tab=threads&status=unanswered&mod=&modAge=&advFil=&postedAfter=&postedBefore=&threadType=all&tm=1477994505548&auth=1
Hi, this is actually the right place to post queries like this.
Answers is for Support and Bug issues and has an SLA to escalate those and get a fix.
The TechCommunity is the place for How-to questions and discussions about the product.
Hope that helps,
Olaf
