Spreadsheet: 156910d1337555645-difficulty-unexpected-behavior-when-conditional-formatting-pivot-pivotexample
Sheet: OpenShipmentPivot

Open Shipment Pivot
ShipTo/Customer | Customer# | ABSARL PO | Customer PO | SO/RMA | Shipper # | Generate Date | Generate Time | Schedule Date | LI | Part Number | Description | Shipper Qty | FG Qty | Shipper Totals | Remaining Inv | RE | WP | SK | RI | MB | SW | WH
Advanced Bionics AG | 190085 |  | 4500001303 | 399336 | 578467 | 05-03-2012 | [NAME] | 04-13-2012 | 3 | CI-7126-TEA | Neptune Covers, Trop Sea | 5 | 0 | 41 | -41 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 4500001308 | 399343 | 577218 | 04-24-2012 | 06:46:20 | 04-13-2012 | 3 | CI-7126-TEA | Neptune Covers, Trop Sea | 1 | 0 | 41 | -41 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 4500001320 | 399652 | 580269 | 05-16-2012 | 16:09:39 | 04-17-2012 | 1 | CI-7126-TEA | Neptune Covers, Trop Sea | 7 | 0 | 41 | -41 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 4500001412 | 401351 | 580270 | 05-16-2012 | 16:09:53 | 05-07-2012 | 2 | CI-7126-TEA | Neptune Covers, Trop Sea | 6 | 0 | 41 | -41 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 4500001418 | 401361 | 580268 | 05-16-2012 | 16:09:16 | 05-07-2012 | 2 | CI-7126-TEA | Neptune Covers, Trop Sea | 1 | 0 | 41 | -41 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 4500001449 | 402478 | 580490 | 05-18-2012 | 10:55:10 | 05-18-2012 | 3 | CI-7126-BLK | Neptune Covers, Onyx | 4 | 1 | 14 | -13 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DHL Global Forwarding SAS | 190085 | 120433 | 4500001338 | 400136 | 580172 | 05-16-2012 | 10:49:23 | 04-23-2012 | 2 | CI-7126-TEA | Neptune Covers, Trop Sea | 10 | 0 | 41 | -41 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 120509 | 4500001413 | 401354 | 580428 | 05-17-2012 | 16:59:58 | 05-07-2012 | 8 | CI-7126-TEA | Neptune Covers, Trop Sea | 10 | 0 | 41 | -41 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Seton Medical Center | 100100 |  | 102136894-0-3500 | 401676 | 579363 | 05-10-2012 | 08:59:32 | 05-09-2012 | 20 | CI-7126-WHT | Neptune Covers Alpine Wht | 1 | 57 | 5 | 52 | 1 | 8 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 21 | CI-7126-BLK | Neptune Covers, Onyx | 1 | 1 | 14 | -13 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 22 | CI-7126-TEA | Neptune Covers, Trop Sea | 1 | 0 | 41 | -41 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sunnybrook Health Sciences Center | 100158 |  | SB12-030491 | 400683 | 580470 | 05-18-2012 | 09:26:27 | 05-18-2012 | 20 | CI-7126-WHT | Neptune Covers Alpine Wht | 1 | 57 | 5 | 52 | 1 | 8 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 21 | CI-7126-BLK | Neptune Covers, Onyx | 1 | 1 | 14 | -13 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 22 | CI-7126-TAU | Neptune Covers, Sand Cast | 1 | 47 | 2 | 45 | 2 | 3 | 0 | 0 | 0 | 0 | 0
Baublitz, [NAME] | 165257 |  | Auth#Bi-lateral.Medi&supp | 399880 | 580400 | 05-17-2012 | 14:04:42 | 05-18-2012 | 22 | CI-7126-BLK | Neptune Covers, Onyx | 1 | 1 | 14 | -13 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 24 | CI-7126-TAU | Neptune Covers, Sand Cast | 1 | 47 | 2 | 45 | 2 | 3 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 25 | CI-7126-BLK | Neptune Covers, Onyx | 1 | 1 | 14 | -13 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Cardinale, Jeremy | 126410 |  | CHARGE#2-0000-2260-10080 | 402340 | 580426 | 05-17-2012 | 16:57:31 | 05-16-2012 | 20 | CI-7126-WHT | Neptune Covers Alpine Wht | 1 | 57 | 5 | 52 | 1 | 8 | 0 | 0 | 0 | 0 | 0
Univ of Alberta Hospital | 100116 |  | 305875 | 391902 | 580455 | 05-18-2012 | 08:02:44 | 04-05-2012 | 21 | CI-7126-BLK | Neptune Covers, Onyx | 1 | 1 | 14 | -13 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 23 | CI-7126-BLK | Neptune Covers, Onyx | 1 | 1 | 14 | -13 | 0 | 0 | 0 | 0 | 0 | 0 | 0
RADY Children's Hosp San Diego | 109395 |  | B15100 | 402462 | 580453 | 05-18-2012 | 07:53:29 | 05-18-2012 | 21 | CI-7126-BLK | Neptune Covers, Onyx | 1 | 1 | 14 | -13 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 22 | CI-7126-WHT | Neptune Covers Alpine Wht | 1 | 57 | 5 | 52 | 1 | 8 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 23 | CI-7126-BLK | Neptune Covers, Onyx | 1 | 1 | 14 | -13 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 24 | CI-7126-WHT | Neptune Covers Alpine Wht | 1 | 57 | 5 | 52 | 1 | 8 | 0 | 0 | 0 | 0 | 0
 | 110164 |  | B15100 | 402460 | 580452 | 05-18-2012 | 07:53:14 | 05-18-2012 | 21 | CI-7126-BLK | Neptune Covers, Onyx | 1 | 1 | 14 | -13 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 23 | CI-7126-BLK | Neptune Covers, Onyx | 1 | 1 | 14 | -13 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Grand Total