Forum Discussion

Bert Joe Twomey's avatar
Bert Joe Twomey
Copper Contributor
Nov 16, 2016
Solved

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 An...
BI & Data Analytics
training
  • Bert Joe Twomey's avatar
    Bert Joe Twomey
    Dec 05, 2016

    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

     

Olaf Hubel's avatar
Olaf Hubel
Former Employee
Dec 02, 2016

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

Resources