Is it possible to keep all the row items showing in a Pivot Table

[Bert Joe Twomey]

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

[#2]

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=th...

[#3]

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

[#4 · Accepted solution]

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=th...

---