G
Guest
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
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