Spreadsheet: 871890d1718286295-how-to-countif-dynamically-based-on-slicer-selection-report-14-juni-me5a-capex-c11-c12-c13-
Sheet: Data

PLANT | PLANT | PURCH GROUP | YEAR | COMBINE | PIC |  |  | No | Plant | Description | Purch Group |  | LIST PURCHASING GROUP
1000 | CMD | C11 | 2024 |  | DIRA |  |  | 1 | 1000 | CMD Head Office | CMD
1000 | CMD | C12 | 2024 |  | DIRA |  |  | 2 | 1001 | CMD Sentul | CMD |  | C01 | General
1000 | CMD | C13 | 2024 |  | DIRA |  |  | 3 | 1002 | CMD Semarang | CMD |  | C02 | Marketing Goods & Services
1001 | CMD | C11 | 2023 |  | EGA |  |  | 4 | 1003 | CMD Pasuruan | CMD |  | C03 | Factory Opex
1001 | CMD | C12 | 2023 |  | DIRA |  |  | 5 | 2000 | MP Head Office | MPP |  | C06 | Consumable Items
1001 | CMD | C13 | 2023 |  | DIRA |  |  | 6 | 2001 | MP [NAME] | MPP |  | C07 | Expedition
1001 | CMD | C11 | 2024 |  | DIRA |  |  | 7 | 2002 | MP Semarang | MPP |  | C08 | General Services
1001 | CMD | C12 | 2024 |  | DIRA |  |  | 8 | 3000 | JESS Head Office | JES |  | C09 | Trade
1001 | CMD | C13 | 2024 |  | DIRA |  |  | 9 | 3001 | JESS Semarang | JES |  | C11 | Asset IT
1002 | CMD | C11 | 2024 |  | AULIA |  |  | 10 | 4000 | MS Head Office | MSN |  | C12 | Asset Non Project (Plant Existing)
1002 | CMD | C12 | 2024 |  | AULIA |  |  | 11 | 4011 | MS CWH Jakarta | MSN |  | C13 | Asset Project (New Plant)
1002 | CMD | C13 | 2024 |  | AULIA |  |  | 12 | 4111 | [NAME]. Jakarta | MSN |  | C14 | General IT Services
1003 | CMD | C11 | 2023 |  | EGA |  |  | 13 | 4121 | [NAME]. Bandung | MSN |  | C17 | Expedition to Customer
1003 | CMD | C12 | 2023 |  | AULIA |  |  | 14 | 4221 | MS Depo Cirebon | MSN
1003 | CMD | C13 | 2023 |  | AULIA |  |  | 15 | 4321 | MS SP Purwakarta | MSN
1003 | CMD | C11 | 2024 |  | AULIA |  |  | 16 | 4322 | MS SP Sukabumi | MSN
1003 | CMD | C12 | 2024 |  | AULIA |  |  | 17 | 4031 | MS CWH Semarang | MSN
1003 | CMD | C13 | 2024 |  | AULIA |  |  | 18 | 4131 | [NAME]. Semarang | MSN
2001 | MPP | C11 | 2023 |  | RADIT |  |  | 19 | 4331 | MS SP Purwokerto | MSN
2001 | MPP | C12 | 2023 |  | RADIT |  |  | 20 | 4241 | MS Depo Jogjakarta | MSN
2001 | MPP | C13 | 2023 |  | RADIT |  |  | 21 | 4051 | MS CWH Pasuruan | MSN
2001 | MPP | C11 | 2024 |  | CHANDRA |  |  | 22 | 4151 | [NAME]. Surabaya | MSN
2001 | MPP | C12 | 2024 |  | CHANDRA |  |  | 23 | 4161 | [NAME]. [NAME] | MSN
2001 | MPP | C13 | 2024 |  | CHANDRA |  |  | 24 | 4141 |  | MSN
2002 | MPP | C11 | 2023 |  | CHANDRA |  |  | 25 | 4251 |  | MSN
2002 | MPP | C12 | 2023 |  | CHANDRA |  |  | 26 | 4231 |  | MSN
2002 | MPP | C13 | 2023 |  | CHANDRA |  |  | 27 | 4331 |  | MSN
2002 | MPP | C11 | 2024 |  | CHANDRA
2002 | MPP | C12 | 2024 |  | CHANDRA |  |  |  |  | 0 | < 0.5 month
2002 | MPP | C13 | 2024 |  | CHANDRA |  |  |  |  | 15 | > 0.5 month <= 1 month
3000 | JESS | C11 | 2024 |  | DITA |  |  |  |  | 31 | > 1 month <= 1.5 month
3000 | JESS | C12 | 2024 |  | DITA |  |  |  |  | 46 | > 1.5 month <= 2 months
3000 | JESS | C13 | 2024 |  | DITA |  |  |  |  | 61 | > 2 months <= 2.5 months
3001 | JESS | C11 | 2023 |  | DITA |  |  |  |  | 76 | > 2.5 months <= 3 months
3001 | JESS | C12 | 2023 |  | DITA |  |  |  |  | 91 | > 3 months
3001 | JESS | C13 | 2023 |  | DITA
3001 | JESS | C11 | 2024 |  | DITA
3001 | JESS | C12 | 2024 |  | DITA |  |  |  |  | Progress Options
3001 | JESS | C13 | 2024 |  | DITA |  |  |  |  | Still no progress
4000 | MSN | C11 | 2023 |  | DIRA |  |  |  |  | User has not sent an email
4000 | MSN | C12 | 2023 |  | DIRA |  |  |  |  | Survey schedulling
4000 | MSN | C13 | 2023 |  | DIRA |  |  |  |  | Request for quotation
4000 | MSN | C11 | 2024 |  | DIRA |  |  |  |  | Review quotation
4000 | MSN | C12 | 2024 |  | DIRA |  |  |  |  | Specification check with user
4000 | MSN | C13 | 2024 |  | DIRA |  |  |  |  | Master vendor
4141 | MSN | C11 | 2024 |  | DIRA |  |  |  |  | Capex approval
4141 | MSN | C12 | 2024 |  | DIRA |  |  |  |  | PO approval
4141 | MSN | C13 | 2024 |  | DIRA |  |  |  |  | PR postponed
4251 | MSN | C11 | 2024 |  | DIRA |  |  |  |  | PR deleted
4251 | MSN | C12 | 2024 |  | DIRA |  |  |  |  | Others
4251 | MSN | C13 | 2024 |  | DIRA
4241 | MSN | C11 | 2024 |  | DIRA
4241 | MSN | C12 | 2024 |  | DIRA
4241 | MSN | C13 | 2024 |  | DIRA
4231 | MSN | C11 | 2024 |  | DIRA
4231 | MSN | C12 | 2024 |  | DIRA
4231 | MSN | C13 | 2024 |  | DIRA
4221 | MSN | C13 | 2024 |  | DIRA
4321 | MSN | C13 | 2024 |  | DIRA
4331 | MSN | C12 | 2024 |  | DIRA
4331 | MSN | C13 | 2024 |  | DIRA