Spreadsheet: 54426d1254404693-finding-difference-in-separate-sheets-using-criteria-to-prepare-for-a-pivot-table-shortfall-24-09-09-1-10-09-pivot-
Sheet: PIVOT TABLE

Row Labels | SKU | Warehouse Location | Sum of Quantity
3 | BDP-020 | E53 | 3
 | BDP-200 | B13 | 1
 | RE-500-BU | ORDER | 1
4 | RE-129-BK | ORDER | 2
 | RE-129-NT | ORDER | 1
 | RE-129-WH | ORDER | 1
 | [NAME] | U05 | 48
 | [NAME] | U04 | 10
 | [NAME] | U09 | 4
 | [NAME] | U07 | 4
 | U-30G-OR | U02 | 1
 | U-30G-PK | U08 | 5
 | [NAME] | U03 | 10
 | [NAME] | U01 | 3
 | U-30G-WH | U06 | 4
 | U-30G-YE | U10 | 5
 | VE-07-RD | A32 | 6
5 | U2-KIT-CBK | J11-J13 | 2
 | U2-KIT-CGN | J19b/J19c | 1
 | U2-KIT-CPK | J16/J17 | 1
 | UI-KIT-WT | J27/29a | 1
 | ULP-1-BK | U11 | 3
 | ULP-1-CS | U12 | 1
 | ULP-1E-BK | U14 | 1
 | ULP-1-VS | U13 | 8
6 | GC-10-SEE-BLU | B37 | 8
 | GC-10-SEE-GRN | B35 | 3
 | GC-10-SEE-RED | B32 | 6
 | GC-20-SEE-BLU | B47 | 5
 | GC-20-SEE-GRN | B31 | 6
 | GC-20-SEE-PUR | B38 | 3
 | GC-20-SEE-RED | B46 | 2
7 | AX-25-N2 | [NAME] | 8
 | AX-27-K | E25 | 1
 | M-032-BC | E24 | 8
8 | PL-10-BW | B56 | 1
 | PL-10-RD | F21 | 1
 | USG-30-BK | J46 | 2
 | USG-30-PK | J31/J32 | 1
 | USG-30-PP | J33/J34 | 2
9 | DVD-CFG3 | G106 | 1
 | [NAME] | C21 | 2
 | DVD-CRG2 | C26 | 2
 | DVD-CRG-ALL | C24 | 1
10 | CBB-6 | D62 | 1
 | HTA-40-BK | E51 | 3
 | HTA-40-WH | D87/D88 | 2
 | UFV-1-BK | J72/J72 | 2
11 | BG-402-NT | B11 | 5
 | PC-20-03H | D79 | 3
 | PC-60-03 | D99 | 1
12 | UK-185 | J28/J29c | 5
 | UNG-30-BK | J51/J52 | 1
 | UNG-30-BU | J57 | 2
 | UNG-30-PP | J53/J54 | 1
13 | GC-104-3BK | D37/D38 | 30
 | GC-104-6BK | D58/D59 | 1
 | GC-105-3BK | E31 | 55
 | GC-105-6BK | D33/D34 | 4
 | GC-NTK-10SA | F45 | 1
 | GC-NTK-6SA | D109 | 2
14 | GC-103-6BU | D55/D56 | 3
 | GC-103-6RD | D46/D47 | 5
 | MXJ-5-BK | D53/D54 | 2
 | MXX-10-BK | D43/D44 | 4
 | MXX-5-BK | D68/D69 | 16
 | SJJ-10-BK | B36** | 2
17 | 72-CL | D75 | 5
 | 92-CLR | G95 | 2
18 | [NAME] | G98 | 1
 | BOD-1 | D104 | 4
 | CS-100 | D85 | 2
 | OC-100 | G34 | 1
19 | BC-80-A | D49 | 12
 | BC-84-B | D23 | 1
 | BC-84-C | D26 | 5
 | BEP-10-BK | D45 | 5
 | BEP-10-CH | D39 | 8
 | BEP-10-GD | [NAME] | 3
 | GFS-25 | B15 | 4
 | MVS-501-BK | D74 | 9
 | MVS-501-CR | D21 | 3
 | MVS-501-GD | D51 | 3
 | [NAME] | [NAME] | 1
20 | AGM-100 | D52 | 3
 | [NAME] | D27 | 2
 | BTU-100 | [NAME] | 2
 | BTU-300 | D22 | 5
 | BTU-305 | D83 | 4
 | GPS-800 | D63 | 4
 | HH-1 | B12 | 6
 | HRM-20-A | D25 | 2
 | HRM-20-C | D48 | 10
 | HRM-20-D | D42 | 2
 | HRM-20-G | D32 | 1
 | LP1-C | C59 | 4
 | LP4-B | D71 | 6
 | LP4-W | C35 | 4
 | MS-GLASS | D66/D67 | 4
 | PH-17 | [NAME] | 9
 | ST-313-B | B28 | 4
 | ST-313-M | G12 | 2
 | TD-10-EPJ | D57 | 6
 | TE-310-B | B25 | 2
21 | PN-1020-R | AB2 | 1
 | PN-1021-M | AB3 | 1
 | SN-1021-M | EF1 | 4
 | SN-1021-R | EF2 | 5
 | SN-1022-M | EF3 | 3
 | SN-1022-R | EF4 | 1
 | TN-1022-R | EF6 | 1
22 | AGN-5A-FLW | B34 | 1
 | FC-510 | E32 | 47
 | HAY-302-B | B44 | 4
 | HAY-305-B | B27 | 1
 | HAY-307-A | B23 | 2
 | HAY-307-AN | B22 | 5
23 | DM-50 | B29a | 4
 | HP-7-M | B63 | 1
 | MG-3 | C81 | 4
 | PS-1 | E41 | 4
24 | D-KIT-7 | B62* | 2
 | HP-7 | B61 | 4
 | RM-7 | D35/D36 | 9
25 | B-25-BG | FAR END E/F | 4
 | CAC-500-D | STORE | 2
 | CJZ-500-16 | STORE | 1
 | CJZ-500-18 | STORE | 1
 | E-25-BG | FAR END C/D | 8
 | W-25-BG | FAR END G/H | 3
26 | BS-105-BK | STORE | 1
 | [NAME] | F51 | 4
 | GS-260-A | E23 | 2
 | GS-270-C | F33 | 2
 | GS-47-BK | E33 | 13
 | MS-1325-BK | B14**** | 1
 | OB-60 | F11 | 10
 | OB-80 | E11 | 19
27 | CYB-70 | A21 | 1
28 | GST-100-BK | STR013 | 1
 | GST-100-RD | STR036 | 2
 | GST-205-BR | STR016 | 2
 | GST-205-PK | STR023 | 2
 | GST-205-PU | STR012 | 1
 | GST-205-WH | STR015 | 5
 | GST-205-YE | STR019 | 1
 | GST-215-RD | STR025 | 1
 | GST-282-BK | STR038 | 2
 | GST-288-BK | STR021 | 5
 | [NAME] | STR030 | 4
 | GST-544-YE | STR031 | 1
 | MSE-MAT-ST | G69 | 1
 | STR-BWS-BLK | STR001 | 10
 | STR-CEL-BLK | STR002 | 10
 | STR-CEL-GRN | STR028 | 1
 | STR-CEL-NAT | STR010 | 2
 | STR-DLX-BLK | STR004 | 3
 | STR-DLX-RED | STR029 | 2
 | STR-DLX-TAN | STR042 | 3
 | STR-PEB-BK | STR032 | 1
 | STR-PEB-BR | STR050 | 1
 | STR-USL-BLK | STR003 | 2
 | STR-USL-DBN | STR009 | 5
 | STR-USL-MAH | STR011 | 1
 | STR-USL-VER | STR061 | 1
 | STR-WVE-BLK | STR022 | 1
 | STR-WVE-BRN | STR008 | 4
 | STR-WVE-PUR | STR044 | 3
 | TS-RK-BK | H14 | 2
 | TS-TWN-BK | H38 | 2
29 | 4-STR-45 | G23 | 2
 | CL-BE | D78 | 5
 | CL-HT | C89 | 1
 | CL-MT | D96 | 3
 | E-10 | D41 | 5
 | E-11 | C96 | 2
 | [NAME] | G67 | 2
 | [NAME] | D73 | 5
 | PB-10 | D97 | 1
 | PB-11 | C91 | 1
 | PB-12 | D93 | 1
AH | 5xKI015WKS | F34 | 1
 | 5xKI030WKS | F31 | 1
AT | ATZ1001 | D64/D65 | 3
BA | BA-34 | H37 | 1
MISC | ZAKK-BULL-WHT | H55/H59 | 1
SNT | 2002 | C18 | 6
 | 2003 | C14 | 3
 | 2004 | C16 | 10
 | 2006 | C17 | 2
 | 2220 | D11 | 16
 | 2221 | D12 | 41
 | 2222 | C11 | 2
 | 2223 | D13 | 34
 | 2626 | C15 | 7
 | 2627 | C12 | 4
 | PP-418P50 | G47 | 2
 | PP-418P60 | G45 | 3
 | PP-418P73 | G48 | 7
 | PP-418P88 | G41 | 2
 | PP-41P15 | G51 | 4
 | PP-41P20 | G57 | 2
 | PP-41P71 | G53 | 1
 | PP-44P10 | G54 | 3
 | PP-44P38 | G55 | 3
 | PP-44P60 | G49 | 4
 | PP-44P88 | G44 | 5
 | PP-474P30 | G61 | 1
 | PP-475P30 | G62 | 1
TR | [NAME] | C45/C46 | 1
 | [NAME] | D94/D95 | 1
 | TRH1B-NK | G35/G36 | 1
 | TRH1B-ZA | C63/C64 | 1
 | TRH1N-NK | C78/C79 | 1
 | TRH1N-ZA | C67/C68 | 1
 | [NAME] | C92/C93 | 1
 | TRH2B-NK | C31/C32 | 1
 | TRH2B-ZA | D101/D102 | 1
 | TRH2N-NK | C73/C74 | 1
 | TRS1SET | [NAME] | 1
 | TRS3SET | B33 | 4
 | TRT1B | D86 | 2
 | TRT1N-NK | D105 | 1
 | TRT2N-NK | C39 | 2
(blank) | (blank) | (blank)
Grand Total |  |  | 968