Spreadsheet: 880646d1728479986-filter-functions-with-combobox-example-rev-1-1-
Sheet: Raw

Company | Month | Level | Partcipant | Training Topic | Department | Training hours | Amount | Result | Accomplish Status | Training Type | Skill Type
A | Jan | Manager | [NAME] | Excel | GA | 6 | 50 | Passed |  | External | A |  |  |  |  |  |  | Topics | Dept | Company | Month
A | Jan | Staff | [NAME] | Excel | HR | 6 | 50 | Passed |  | External | A |  |  |  |  |  |  | Excel | GA | A | Jan
A | Feb | Staff | Marlyn | Excel | HR | 6 | 50 | Passed |  | External | A | Cell link Topics | 4 |  |  |  |  | Powerpoint | HR | B | Feb
B | Feb | Manager | [NAME] | Excel | Sales | 6 | 55 | Passed |  | External | D | Cell link Dept | 6 |  |  |  |  | Power BI | Sales | C | Mar
B | Mar | Manager | [NAME] | Powerpoint | Sales | 5 | 30 | Not Passed |  | Internal | B | Cell link Company | 4 |  |  |  |  | ALL | Finance | ALL | Apr
B | Mar | Staff | Cathy | Powerpoint | Finance | 5 | 30 | Passed |  | Internal | B | Cell link month | 5 |  |  |  |  |  | Logistics |  | ALL
C | Mar | Staff | [NAME] | Power BI | Finance | 7 | 60 | Not Passed |  | External | C |  | Topics |  |  |  |  |  | ALL
C | Mar | Staff | Michelle | Powerpoint | Logistics | 5 | 50 | Passed |  | Internal | B
C | Apr | Staff | Michelle | Excel | Logistics | 6 | 60 | Passed |  | External | D
 |  |  |  |  |  |  |  |  |  |  |  |  | Dept
 | Total Employee
 | Total Accomplished Participant
 | Total Topics |  |  |  |  |  |  |  |  |  |  |  | Company
 | Total Training Hours
 | Total Expenses
 |  |  |  |  |  |  |  |  |  |  |  |  | Month
 |  | Total Participant accomplished
 | Dept | Jan | Feb | Mar | Apr |  |  |  | Jan | Feb | Mar | Apr
 | GA |  |  |  |  |  |  | GA | 1
 | HR |  |  |  |  |  |  | HR
 | Sales |  |  |  |  |  |  | Sales |  | 1 | 1
 | Finance |  |  |  |  |  |  | Finance |  |  | 1
 | Logistics |  |  |  |  |  |  | Logistics |  |  | 1 | 1
 |  | Total Participant accomplished
 | Training Type | Jan | Feb | Mar | Apr |  |  |  | Jan | Feb | Mar | Apr
 | External |  |  |  |  |  |  | External | 1 | 1 | 1 | 1
 | Internal |  |  |  |  |  |  | Internal |  |  | 2
 |  | Total Participant accomplished
 | Status | Jan | Feb | Mar | Apr |  |  |  | Jan | Feb | Mar | Apr
 | Accomplish |  |  |  |  |  |  | Accomplish | 1 | 1 | 3 | 1
 | Not Accomplish |  |  |  |  |  |  | Not Accomplish | 1 | 1 | 1
 |  | Total Participant accomplished
 | Level | Jan | Feb | Mar | Apr |  |  |  | Jan | Feb | Mar | Apr
 | Staff |  |  |  |  |  |  | Manager | 1 | 1 | 1
 | Manager |  |  |  |  |  |  | Staff |  |  | 2 | 1
 |  | Total Expense
 | Dept | Jan | Feb | Mar | Apr |  |  |  | Jan | Feb | Mar | Apr
 | GA |  |  |  |  |  |  | GA | 50 | 0 | 0 | 0
 | HR |  |  |  |  |  |  | HR | 50 | 50 | 0 | 0
 | Sales |  |  |  |  |  |  | Sales | 0 | 55 | 30 | 0
 | Finance |  |  |  |  |  |  | Finance | 0 | 0 | 90 | 0
 | Logistics |  |  |  |  |  |  | Logistics | 0 | 0 | 50 | 60
 |  | Total Participant accomplished skill type C
 | Dept | Jan | Feb | Mar | Apr |  |  |  | Jan | Feb | Mar | Apr
 | GA |  |  |  |  |  |  | GA
 | HR |  |  |  |  |  |  | HR
 | Sales |  |  |  |  |  |  | Sales
 | Finance |  |  |  |  |  |  | Finance |  |  | 1
 | Logistics |  |  |  |  |  |  | Logistics