Spreadsheet: 544768d1509023032-best-way-to-have-multi-level-filtering-pivot-count-by-skill-filtered
Sheet: Skills Database

Employee ID | Type | Skill |  |  |  |  |  |  |  |  |  |  | Advnaced Filter Method selects OR >> | Skill |  | Employee ID | Type | Skill |  | Pivot from Advanced Filter, Sorted by [NAME]
41179 | Equipment | Sit down |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | 41179 | Equipment | Sit down
41179 | Equipment | Stand up |  |  |  |  |  | Pivot Table Answer Below Sort by Count Total |  |  |  |  |  | Stand Up |  | 41179 | Equipment | Stand up |  | Count of Type | Column Labels
41179 | Warehousing | Production/Assembly |  | Criteria 1 | [NAME] | Criteria 3 |  |  |  |  |  |  |  | [NAME] |  | 41233 | WMS | Infor |  | Row Labels | Infor | Sit down | Stand up | Grand Total
41233 | WMS | Infor |  | [NAME] | Stand Up | Infor |  | Count of Skill | Column Labels |  |  |  |  |  |  | 41233 | Equipment | Sit down |  | 41233 | 1 | 1 | 1 | 3
41233 | WMS | Syspro |  |  |  |  |  | Row Labels | Infor | Sit down | Stand up | Grand Total |  |  |  | 41233 | Equipment | Stand up |  | 41562 | 1 | 1 | 1 | 3
41233 | Equipment | Sit down |  | Results | Results | Results |  | 41233 | 1 | 1 | 1 | 3 |  |  |  | 41143 | WMS | Infor |  | 41185 | 1 | 1 | 1 | 3
41233 | Equipment | Stand up |  | 41233 | 41233 | 41233 |  | 41562 | 1 | 1 | 1 | 3 |  |  |  | 41389 | Equipment | Sit down |  | 41179 |  | 1 | 1 | 2
41233 | Warehousing | Inventory Control |  | 41183 | 41183 | 41185 |  | 41185 | 1 | 1 | 1 | 3 |  |  |  | 41183 | Equipment | Sit down |  | 41183 |  | 1 | 1 | 2
41233 | Warehousing | LEAN |  | 41185 | 41185 | 41562 |  | 41179 |  | 1 | 1 | 2 |  |  |  | 41183 | Equipment | Stand up |  | 41854 | 1 |  | 1 | 2
41233 | Warehousing | Order Picking |  | 41562 | 41562 |  |  | 41183 |  | 1 | 1 | 2 |  |  |  | 41854 | WMS | Infor |  | 41425 |  |  | 1 | 1
41233 | Warehousing | Receiving |  | 41389 | 41179 |  |  | 41854 | 1 |  | 1 | 2 |  |  |  | 41854 | Equipment | Stand up |  | 41065 | 1 |  |  | 1
41143 | WMS | Infor |  | 41179 |  |  |  | 41425 |  |  | 1 | 1 |  |  |  | 41425 | Equipment | Stand up |  | 41143 | 1 |  |  | 1
41143 | WMS | Syspro |  |  |  |  |  | 41065 | 1 |  |  | 1 |  |  |  | 41185 | WMS | Infor |  | 41389 |  | 1 |  | 1
41143 | Warehousing | Inventory Control |  | 6 Results | 5 Results | 3 Results |  | 41143 | 1 |  |  | 1 |  |  |  | 41185 | Equipment | Sit down |  | Grand Total | 6 | 6 | 7 | 19
41389 | WMS | Syspro |  |  |  |  |  | 41389 |  | 1 |  | 1 |  |  |  | 41185 | Equipment | Stand up
41389 | Equipment | Sit down |  |  |  |  |  | Grand Total | 6 | 6 | 7 | 19 |  |  |  | 41562 | WMS | Infor
41389 | Warehousing | Inventory Control |  |  |  |  |  |  |  |  |  |  |  |  |  | 41562 | Equipment | Sit down
41389 | Warehousing | LEAN |  |  |  |  |  |  |  |  |  |  |  |  |  | 41562 | Equipment | Stand up
41389 | Warehousing | Order Picking |  |  |  |  |  |  |  |  |  |  |  |  |  | 41065 | WMS | Infor
41183 | WMS | Syspro
41183 | Equipment | Box Clamp
41183 | Equipment | Order Picker
41183 | Equipment | Single Double
41183 | Equipment | Sit down
41183 | Equipment | Stand up
41183 | Equipment | [NAME]
41183 | Warehousing | Inventory Control
41183 | Warehousing | LEAN
41183 | Warehousing | Order Picking
41183 | Warehousing | Order Processing
41183 | Warehousing | Pack-Out
41183 | Warehousing | Production/Assembly
41183 | Warehousing | Receiving
41183 | OCF | Pick to Light
41854 | WMS | Infor
41854 | WMS | Softeon
41854 | Equipment | Articulating Clamp
41854 | Equipment | Box Clamp
41854 | Equipment | Layer picker
41854 | Equipment | Reach
41854 | Equipment | Single Double
41854 | Equipment | Slip Sheet
41854 | Equipment | Stand up
41854 | Warehousing | LEAN
41854 | Warehousing | Order Picking
41854 | Warehousing | Pack-Out
41854 | Warehousing | Production/Assembly
41854 | Warehousing | Receiving
41854 | Warehousing | RF Experience
41854 | Warehousing | Specialized Outbound
41854 | OCF | Pick Cart
41854 | OCF | Pick to Light
41854 | OCF | PLC/Automation
41425 | WMS | Enspire
41425 | WMS | Pro Ship
41425 | WMS | Red Prairie
41425 | WMS | Syspro
41425 | Equipment | Box Clamp
41425 | Equipment | Drum Clamp
41425 | Equipment | Single Double
41425 | Equipment | Stand up
41425 | Warehousing | Inventory Control
41425 | Warehousing | Production/Assembly
41425 | Warehousing | Receiving
41425 | Warehousing | Safety Coordinator
41425 | Warehousing | Specialized Outbound
41425 | OCF | A Frame
41425 | OCF | Pick to Light
41425 | OCF | PLC/Automation
41425 | OCF | Put Wall
41185 | WMS | Infor
41185 | WMS | SAP
41185 | Equipment | Articulating Clamp
41185 | Equipment | Box Clamp
41185 | Equipment | Drum Clamp
41185 | Equipment | Roll Clamp
41185 | Equipment | Sit down
41185 | Equipment | Slip Sheet
41185 | Equipment | Stand up
41185 | Equipment | [NAME]
41185 | Warehousing | Inventory Control
41185 | Warehousing | LEAN
41185 | Warehousing | Order Processing
41185 | Warehousing | Receiving
41185 | Warehousing | RF Experience
41185 | Warehousing | Safety Coordinator
41185 | OCF | Pick Cart
41185 | OCF | Pick to Light
41562 | WMS | Infor
41562 | WMS | Red Prairie
41562 | WMS | Softeon
41562 | WMS | Swisslog
41562 | Equipment | Layer picker
41562 | Equipment | Roll Clamp
41562 | Equipment | Sit down
41562 | Equipment | Stand up
41562 | Warehousing | Order Picking
41562 | Warehousing | Pack-Out
41562 | Warehousing | Quality Control
41562 | Warehousing | Returns Processing
41562 | Warehousing | Safety Coordinator
41065 | WMS | Infor
41065 | WMS | Red Prairie
41065 | WMS | Softeon
41065 | Equipment | Drum Clamp
41065 | Equipment | Order Picker
41065 | Equipment | Single Double
41065 | Warehousing | Order Picking
41065 | Warehousing | Quality Control
41065 | Warehousing | Returns Processing
41065 | OCF | A Frame
41065 | OCF | Picking Carousel
41065 | OCF | Put Wall