Spreadsheet: 61418d1262260190-how-to-create-pivot-table-and-changing-the-blank-cell-with-or-0-sample
Sheet: data

DATE | CUSTOMER | DELIVERY NOTE | FKT | ITEM ORDER NUMBER | ITEMS | CRT OUT | PCS OUT | CRT IN | PCS IN | CRT FROM FACTORY IN | PCS FROM FACTORY | RETUR CRT | RETURN PCS | TOTAL CRT | TOTAL KLG | KET | LAIN2 | HELPER | DRIVER | KONDISI
2009-12-01 00:00:00 | FLY | 003 |  | DO=00627 | BMB | 2 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | SENIOR | 007 |  | DO=00628 | BMB | 2 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | TRANSFER IN | BPB091201 |  | VPB = 245 | BMB |  |  |  |  | 500
2009-12-01 00:00:00 | INN KEEP | BR0911165 |  | RT=02076 | BMB |  |  |  |  |  |  |  | 12 |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | LEAF | BR0911168 |  | RT=02079 | BMB |  |  |  |  |  |  |  | 69
2009-12-01 00:00:00 | FLY | 003 |  | DO=00627 | BMK | 1 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | SENIOR | 007 |  | DO=00628 | BMK | 1 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | INN KEEP | BR0911165 |  | RT=02076 | BMK |  |  |  |  |  |  |  | 64 |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | LEAF | BR0911168 |  | RT=02079 | BMK |  |  |  |  |  |  |  | 76
2009-12-01 00:00:00 | SUPRA | 236 |  | 01627 | BSB |  | 6 |  |  |  |  |  |  |  |  |  |  | ERICK
2009-12-01 00:00:00 | SUPRA | 236 |  | 01627 | BSK |  | 12 |  |  |  |  |  |  |  |  |  |  | ERICK
2009-12-01 00:00:00 | TRANSFER OUT | BPG091201 |  |  | BSK | 6
2009-12-01 00:00:00 | TRANSFER IN | BPG091202 |  |  | BSK SP10 |  |  | 6
2009-12-01 00:00:00 | SUPRA | 236 |  | 01627 | BTF |  | 6 |  |  |  |  |  |  |  |  |  |  | ERICK
2009-12-01 00:00:00 | SUPRA | 236 |  | 01627 | MMB |  | 6 |  |  |  |  |  |  |  |  |  |  | ERICK
2009-12-01 00:00:00 | KITE | 2801 |  | 01624 | MMB | 4 |  |  |  |  |  |  |  |  |  |  |  | ERWIN
2009-12-01 00:00:00 | ESCAT | 2802 |  | 01624 | MMB | 1 |  |  |  |  |  |  |  |  |  |  |  | ERWIN
2009-12-01 00:00:00 | KITE | 2801 |  | 01624 | MMK | 2 |  |  |  |  |  |  |  |  |  |  |  | ERWIN
2009-12-01 00:00:00 | ESCAT | 2802 |  | 01624 | MMK | 2 |  |  |  |  |  |  |  |  |  |  |  | ERWIN
2009-12-01 00:00:00 | DONNY | 249 |  | 01626 | MSB | 29 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | SPONGE | 2792 |  | 01626 | MSB | 1 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | PATRCIK | 001 |  | 01626 | MSB | 11 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | KITE | 002 |  | 01625 | MSB | 15 |  |  |  |  |  |  |  |  |  |  |  | STEPHEN
2009-12-01 00:00:00 | FLY | 003 |  | DO=00627 | MSB | 3 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | JUNIOR | 005 |  | 01629 | MSB | 100 |  |  |  |  |  |  |  |  |  |  |  | SEAGEL
2009-12-01 00:00:00 | SENIOR | 007 |  | DO=00628 | MSB | 3 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | LONDON | 239 |  | 01619 | MSB | 100 |  |  |  |  |  |  |  |  |  |  |  | LOLY
2009-12-01 00:00:00 | LISBON | 244 |  | 01627 | MSB | 75 |  |  |  |  |  |  |  |  |  |  |  | ERICK
2009-12-01 00:00:00 | MANSION | 245 |  | 01628 | MSB | 34 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | SURPRISE | 247 |  | 01628 | MSB | 25 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | SURPRISE | 250 |  | 01628 | MSB | 28 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | LONDON | 257 |  | 01625 | MSB | 19 |  |  |  |  |  |  |  |  |  |  |  | STEPHEN
2009-12-01 00:00:00 | SUPRA | 2794 |  | 01625 | MSB | 1 |  |  |  |  |  |  |  |  |  |  |  | STEPHEN
2009-12-01 00:00:00 | KITE | 2801 |  | 01624 | MSB | 6 |  |  |  |  |  |  |  |  |  |  |  | ERWIN
2009-12-01 00:00:00 | DRAGON | BR0911157 |  | RT=02068 | MSB |  |  |  |  |  |  |  | 11 |  |  | RETUR YBS NO:14193 |  | ERICK |  | PC
2009-12-01 00:00:00 | INN KEEP | BR0911165 |  | RT=02076 | MSB |  |  |  |  |  |  |  | 102 |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | LEAF | BR0911168 |  | RT=02079 | MSB |  |  |  |  |  |  |  | 129
2009-12-01 00:00:00 | DONNY | 249 |  | 01626 | MSC | 2 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | SPONGE | 2792 |  | 01626 | MSC | 1 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | FLY | 003 |  | DO=00627 | MSC | 1 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | JUNIOR | 005 |  | 01629 | MSC | 2 |  |  |  |  |  |  |  |  |  |  |  | SEAGEL
2009-12-01 00:00:00 | SENIOR | 007 |  | DO=00628 | MSC | 1 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | MANSION | 245 |  | 01628 | MSC | 2 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | SURPRISE | 250 |  | 01628 | MSC | 2 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | LONDON | 257 |  | 01625 | MSC | 2 |  |  |  |  |  |  |  |  |  |  |  | STEPHEN
2009-12-01 00:00:00 | KITE | 2801 |  | 01624 | MSC | 8 |  |  |  |  |  |  |  |  |  |  |  | ERWIN
2009-12-01 00:00:00 | INN KEEP | BR0911165 |  | RT=02076 | MSC |  |  |  |  |  |  |  | 100 |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | LEAF | BR0911168 |  | RT=02079 | MSC |  |  |  |  |  |  |  | 88
2009-12-01 00:00:00 | DONNY | 249 |  | 01626 | MSCB | 1 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | FLY | 003 |  | DO=00627 | MSCB | 1 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | JUNIOR | 005 |  | 01629 | MSCB | 3 |  |  |  |  |  |  |  |  |  |  |  | SEAGEL
2009-12-01 00:00:00 | SENIOR | 007 |  | DO=00628 | MSCB | 1 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | MANSION | 245 |  | 01628 | MSCB | 1 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | SURPRISE | 250 |  | 01628 | MSCB | 1 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | LONDON | 257 |  | 01625 | MSCB | 1 |  |  |  |  |  |  |  |  |  |  |  | STEPHEN
2009-12-01 00:00:00 | KITE | 2801 |  | 01624 | MSCB | 2 |  |  |  |  |  |  |  |  |  |  |  | ERWIN
2009-12-01 00:00:00 | INN KEEP | BR0911165 |  | RT=02076 | MSCB |  |  |  |  |  |  |  | 48 |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | LEAF | BR0911168 |  | RT=02079 | MSCB |  |  |  |  |  |  |  | 48
2009-12-01 00:00:00 | DONNY | 249 |  | 01626 | MSK | 30 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | SPONGE | 2792 |  | 01626 | MSK | 1 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | PATRCIK | 001 |  | 01626 | MSK | 20 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | KITE | 002 |  | 01625 | MSK | 20 |  |  |  |  |  |  |  |  |  |  |  | STEPHEN
2009-12-01 00:00:00 | FLY | 003 |  | DO=00627 | MSK | 3 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | JUNIOR | 005 |  | 01629 | MSK | 170 |  |  |  |  |  |  |  |  |  |  |  | SEAGEL
2009-12-01 00:00:00 | SENIOR | 007 |  | DO=00628 | MSK | 3 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | GENESIS | 212 |  | 01628 | MSK | 6 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | LONDON | 239 |  | 01619 | MSK | 100 |  |  |  |  |  |  |  |  |  |  |  | LOLY
2009-12-01 00:00:00 | LISBON | 244 |  | 01627 | MSK | 75 |  |  |  |  |  |  |  |  |  |  |  | ERICK
2009-12-01 00:00:00 | MANSION | 245 |  | 01628 | MSK | 23 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | SURPRISE | 247 |  | 01628 | MSK | 6 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | SURPRISE | 250 |  | 01628 | MSK | 29 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | LONDON | 257 |  | 01625 | MSK | 58 |  |  |  |  |  |  |  |  |  |  |  | STEPHEN
2009-12-01 00:00:00 | SUPRA | 2784 |  | 01625 | MSK | 4 |  |  |  |  |  |  |  |  |  |  |  | STEPHEN
2009-12-01 00:00:00 | SUPRA | 2794 |  | 01625 | MSK | 1 |  |  |  |  |  |  |  |  |  |  |  | STEPHEN
2009-12-01 00:00:00 | KITE | 2801 |  | 01624 | MSK | 14 |  |  |  |  |  |  |  |  |  |  |  | ERWIN
2009-12-01 00:00:00 | ESCAT | 2802 |  | 01624 | MSK | 1 |  |  |  |  |  |  |  |  |  |  |  | ERWIN
2009-12-01 00:00:00 | TRANSFER IN | BPB091201 |  | VPB = 245 | MSK |  |  |  |  | 750
2009-12-01 00:00:00 | DRAGON | BR0911157 |  | RT=02068 | MSK |  |  |  |  |  |  |  | 2 |  |  | RETUR YBS NO:14193 |  | ERICK |  | PC
2009-12-01 00:00:00 | INN KEEP | BR0911165 |  | RT=02076 | MSK |  |  |  |  |  |  |  | 274 |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | LEAF | BR0911168 |  | RT=02079 | MSK |  |  |  |  |  |  |  | 136
2009-12-01 00:00:00 | KITE | 2801 |  | 01624 | MTPP | 1 |  |  |  |  |  |  |  |  |  |  |  | ERWIN
2009-12-01 00:00:00 | ESCAT | 2771 |  | 01626 | MTRC | 1 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | SUPRA | 236 |  | 01627 | MTRC |  | 12 |  |  |  |  |  |  |  |  |  |  | ERICK
2009-12-01 00:00:00 | SUPRA | 2800 |  | 01625 | MTRC | 2 |  |  |  |  |  |  |  |  |  |  |  | STEPHEN
2009-12-01 00:00:00 | KITE | 2801 |  | 01624 | MTRC | 18 |  |  |  |  |  |  |  |  |  |  |  | ERWIN
2009-12-01 00:00:00 | TRANSFER OUT | BPG091201 |  |  | MTRC | 4
2009-12-01 00:00:00 | TRANSFER IN | BPG091202 |  |  | MTRC SP2 |  |  | 4
2009-12-01 00:00:00 | KITE | 2801 |  | 01624 | MTSB | 7 |  |  |  |  |  |  |  |  |  |  |  | ERWIN
2009-12-01 00:00:00 | ESCAT | 2802 |  | 01624 | MTSB | 2 |  |  |  |  |  |  |  |  |  |  |  | ERWIN
2009-12-01 00:00:00 | ESCAT | 2771 |  | 01626 | MTSG | 1 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | SUPRA | 2794 |  | 01625 | MTSG | 1 |  |  |  |  |  |  |  |  |  |  |  | STEPHEN
2009-12-01 00:00:00 | KITE | 2800 |  | 01625 | MTSG | 2 |  |  |  |  |  |  |  |  |  |  |  | STEPHEN
2009-12-01 00:00:00 | KITE | 2801 |  | 01624 | MTSG | 19 |  |  |  |  |  |  |  |  |  |  |  | ERWIN
2009-12-01 00:00:00 | ESCAT | 2802 |  | 01624 | MTSG | 2 |  |  |  |  |  |  |  |  |  |  |  | ERWIN
2009-12-01 00:00:00 | TRANSFER IN | BPB091201 |  | VPB = 245 | MTSG |  |  |  |  | 100
2009-12-01 00:00:00 | TRANSFER OUT | BPG091201 |  |  | MTSG | 4
2009-12-01 00:00:00 | TRANSFER IN | BPG091202 |  |  | [NAME] |  |  | 4
2009-12-01 00:00:00 | SPONGE | 2792 |  | 01626 | MTSW | 1 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | KITE | 2801 |  | 01624 | MTSW |  | 48 |  |  |  |  |  |  |  |  |  |  | ERWIN
2009-12-01 00:00:00 | ESCAT | 2771 |  | 01626 | MTVO | 1 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | TRANSFER OUT | BPG091201 |  |  | MTVO | 6
2009-12-01 00:00:00 | HONDURAS | 2804 |  | 01627 | MTVO @48 | 1 |  |  |  |  |  |  |  |  |  |  |  | ERICK
2009-12-01 00:00:00 | TRANSFER IN | BPG091202 |  |  | MTVO SP2 |  |  | 6
2009-12-01 00:00:00 | FLY | 003 |  | DO=00627 | PMB | 1 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | SENIOR | 007 |  | DO=00628 | PMB | 1 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | INN KEEP | BR0911165 |  | RT=02076 | PMB |  |  |  |  |  |  |  | 24 |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | LEAF | BR0911168 |  | RT=02079 | PMB |  |  |  |  |  |  |  | 24
2009-12-01 00:00:00 | FLY | 003 |  | DO=00627 | PMK | 1 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | SENIOR | 007 |  | DO=00628 | PMK | 1 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | INN KEEP | BR0911165 |  | RT=02076 | PMK |  |  |  |  |  |  |  | 50 |  |  |  |  |  | [NAME]
2009-12-01 00:00:00 | LEAF | BR0911168 |  | RT=02079 | PMK |  |  |  |  |  |  |  | 50
2009-12-01 00:00:00 | HOMEMADE COOKIES | 004 |  | 01624 | SJLCO | 5 |  |  |  |  |  |  |  |  |  |  |  | ERWIN
2009-12-01 00:00:00 | SENIOR | 006 |  | 01625 | SJLCO | 15 |  |  |  |  |  |  |  |  |  |  |  | STEPHEN
2009-12-01 00:00:00 | HONDURAS | 2804 |  | 01627 | SJLCO | 1 |  |  |  |  |  |  |  |  |  |  |  | ERICK