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

     

Bert Joe Twomey's avatar
Bert Joe Twomey
Copper Contributor
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

 

Resources