Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to do calculations with Null in the column? | Excel Discussion (Misc queries) | |||
Pivot tables with zero/null values | Excel Discussion (Misc queries) | |||
How do I Excel countif column a =? and column b = null ? | Excel Worksheet Functions | |||
Pivot table format changes if value of source data is null | Excel Discussion (Misc queries) | |||
Preventing NULL showing as 0 on a pivot chart using Office Web Component. | Charts and Charting in Excel |