Spreadsheet: 143220d1330304998-problems-with-pivot-table-sales-summary-test
Sheet: Data

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Margin
Channel | Brand | Customer | Month | GM $ | GM % pu | Order Number | Order Co | Line Number | Sold To Number | Sold To Name | Quantity Ordered | Quantity Sold | UM | Unit Price | Sales Value | % Profit Margin | [NAME] | Ship To Number | Ship To Name | Last Stat | Next Stat | Customer PO | 2nd Item Number | Item Description | Item Description 2 | 3rd Item Number | Short Item No | Request Date | Invoice Number | Inv Type | Invoice Company | [NAME] | Order Date | Sched Pick | Original Promised | Actual Ship | Invoice Date | Cancel Date | G/L Date | Sls Cd1 | Sls Cd2 | Sls Cd3 | Sls Cd4 | Sls Cd5 | Unit Cost | Extended Cost | Business Unit
Brands | Product A | Customer A |  |  |  | 942 | 00010 | 1 | 3510 | Customer A | 1 | 1 | EA | 1.2 | 1.2 | 0.2083333333333333 | AUD | 5401 | Customer A | 580 | 620 | PO32840 | 101111 | Small screw | 20mm | 101111 | 101111 | 2011-12-07 00:00:00 | 255357 | RM | 00010 | NR | 2011-12-07 00:00:00 | 2011-12-07 00:00:00 | 2011-10-10 00:00:00 |  | 2011-12-07 00:00:00 |  |  | CBF | C | Z | O | CZO | 0.25 | 0.25 | 310
Brands | Product B | Customer B |  |  |  | 943 | 00010 | 1 | 5670 | Customer B | 15 | 15 | EA | 1.3 | 19.5 | 0.1923076923076923 | AUD | 5971 | Customer B | 580 | 620 | 3677 | 101112 | Medium screw | 30[NAME] | 101112 | 101112 | 2011-12-07 00:00:00 | 255358 | RM | 00010 | NR | 2011-12-07 00:00:00 | 2011-12-07 00:00:00 | 2011-09-26 00:00:00 |  | 2011-12-07 00:00:00 |  |  | CAB | C | Z | AA | CZ2 | 0.25 | 3.75 | 310
Private Label | Product C | Customer C |  |  |  | 944 | 00010 | 1 | 6390 | Customer C | 25 | 500 | EA | 1.4 | 35 | 0.2428571428571429 | AUD | 6391 | Customer C | 580 | 620 | ON CHARGES | 101113 | Large Screw | 40mm | 101113 | 101113 | 2011-12-07 00:00:00 | 255359 | RM | 00010 | NR | 2011-12-07 00:00:00 | 2011-12-07 00:00:00 | 2011-09-29 00:00:00 |  | 2011-12-07 00:00:00 |  |  | CCE | G |  |  | GO+ | 0.34 | 8.5 | 310
Contract | Product A | Customer D |  |  |  | 945 | 00010 | 1 | 3510 | Customer D | 200 | 200 | EA | 1.09 | 218 | 0.4128440366972477 | AUD | 5401 | Customer D | 580 | 620 | PO32840 | 101111 | Small screw | 20mm | 101111 | 101111 | 2011-12-12 00:00:00 | 255411 | RM | 00010 | C | 2011-12-12 00:00:00 | 2011-12-12 00:00:00 | 2011-10-10 00:00:00 |  | 2011-12-12 00:00:00 |  |  | CBF | C | Z | O | CZO | 0.45 | 90 | 310
Brands | Product B | Customer A |  |  |  | 946 | 00010 | 1 | 3510 | Customer A | 45 | 45 | EA | 0.67 | 30.15 | 0.5074626865671642 | AUD | 5401 | Customer A | 580 | 620 | PO32850 | 101112 | Small screw | 20mm | 101111 | 101111 | 2011-12-13 00:00:00 | 255417 | RM | 00010 | NR | 2011-12-13 00:00:00 | 2011-12-13 00:00:00 | 2011-12-05 00:00:00 |  | 2011-12-13 00:00:00 |  |  | CBF | C | Z | O | CZO | 0.34 | 15.3 | 310
Private Label | Product C | Customer B |  |  |  | 947 | 00010 | 1 | 3510 | Customer B | 67 | 67 | EA | 0.83 | 55.61 | 0.8072289156626506 | AUD | 5401 | Customer B | 580 | 620 | PO32840 | 101112 | Large Screw | 40mm | 101112 | 101112 | 2011-12-16 00:00:00 | 255893 | RM | 00010 | NR | 2011-12-16 00:00:00 | 2011-12-16 00:00:00 | 2011-12-12 00:00:00 |  | 2011-12-16 00:00:00 |  |  | CBF | C | Z | O | CZO | 0.67 | 44.89 | 310
Contract | Product A | Customer C |  |  |  | 948 | 00010 | 1 | 3510 | Customer C | 89 | 89 | EA | 2 | 178 | 0.4550000000000001 | AUD | 5401 | Customer C | 580 | 620 | PO32846 | 101113 | Small screw | 20mm | 101113 | 101113 | 2011-12-16 00:00:00 | 255894 | RM | 00010 | NR | 2011-12-16 00:00:00 | 2011-12-16 00:00:00 | 2011-11-03 00:00:00 |  | 2011-12-16 00:00:00 |  |  | CBF | C | Z | O | CZO | 0.91 | 80.99000000000001 | 310
Brands | Product B | Customer D |  |  |  | 948 | 00010 | 2 | 3510 | Customer D | 345 | 345 | EA | 1.11 | 382.95 | 0.2972972972972973 | AUD | 5401 | Customer D | 580 | 620 | PO32846 | 101112 | Medium screw | 30[NAME] | 101112 | 101112 | 2011-12-16 00:00:00 | 255894 | RM | 00010 | NR | 2011-12-16 00:00:00 | 2011-12-16 00:00:00 | 2011-11-03 00:00:00 |  | 2011-12-16 00:00:00 |  |  | CBF | C | Z | O | CZO | 0.33 | 113.85 | 310