It took several hours to "sanitize" this report.
I have a report that downloads Open Purchase Order Data and calculates whether the vendor made the promised delivery date. I need to report this data by vendor, so I thought a pivot table would be the easiest way to do this.
The ID for the vendor with which I am having a problem is ID00048. A record is unique based on the combination of PO Number, Line and Release (PLR).
The two PLRs (Column E in both Pivot Table and source data) are 164537-1-2 and 165364-3-2. These records are highlighted in yellow in both the pivot table and source data.
The source data indicates that there is data for the open quantity and unit cost for both these records. However, the pivot table indicates that they are null - not "(blank)".
The pivot table is set up to repeat all settings. Why is it not repeating these specific settings?
There is at least one other vendor with the same issue. Interestingly, it too has a problem when the supplier quantity is 14. (EDIT: I've since checked. This error happens whenever the supplier quantity is 14. If you move the quantity to the left in the pivot table, then the other numbers come on line).
I can get the "correct answer" by moving the quantities to the values section of the pivot table instead of making them rows. However, the format in the report is the one the group uses. I was hoping to get away with a simple copy/paste into a table, and ship it off to the customer. If I make the quantities values I have to unscramble the columns which I can do, but I would like to know WHY the pivot table isn't repeating the headers.
Bookmarks