New to messing with Pivot tables and trying to play with it (and learn on my own) before going to consultant. Outline of chart I want to display, spreadsheet shows all possible lines, so I want to be able to show total amount of lines on one axis. We then have a column E "QuantityBackordered", if this column has a value > 0 I want to show these lines/rows (total) on another axis. Example attached would show 4 total possible lines with 2 lines containing BOQTY's. The main calculation I am trying to display is my order fill rate, which in this example would be 50% 2 lines have 0 backordered out of 4. Could I display the 50% in the same pivot chart? Thinking just a regular line chart ?
| Book1 | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | |||
| 1 | ItemCode | ItemCodeDesc | WarehouseCode | QuantityOrdered | QuantityBackordered | UDF_QTY_PULLED | UDF_INVENTORIED_ITEM | ||
| 2 | 1332L | 1332L TIG WELDING GLOVE CUT RE | 000 | 48 | 48 | 0 | Y | ||
| 3 | 1332L | 1332L TIG WELDING GLOVE CUT RE | 000 | 84 | 0 | 84 | Y | ||
| 4 | 10019063-GRAY-XLR | MNS FR SLD VENT LS WRK SHRT SI | 000 | 5 | 0 | 5 | Y | ||
| 5 | CDKW038-NAVYBLUE | 20 oz. Viking Nova Tumbler | 000 | 48 | 48 | 0 | Y | ||
Order_Fill_Rate | |||||||||
