View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Adam Adam is offline
external usenet poster
 
Posts: 287
Default Column in Pivot gets deleted if Null??

Okay, I could really use some help. I have built a pivot that has two table
fields, two column fields, and several data fields. My table fields are
"Month" and "Region", and my column fields are "Quality" and "Bin". I have
several calculation that feed off of the data within this pivot. My problem
is, when there is not a data point within a specified "Quality" and "Bin",
the pivot deletes the column. This messes up all of my formulas.

I have attempted to use the "Show Items with no data" feature within Field
Settings, but it listed all of my "Bin's" within each "Quality". That is not
how my data is set up. Certain "Bin's" need to be assigned to "Quality"
levels.

Any help on having the pivot recognize a Null and not deleting the column,
would be greatly appreciated.

Thanks