Project 2 - Create a report using PowerQuery, Macro VBA, List Functions and Data Validation functions for Data Reporting of Supply Chain Management companies
| Scenario Summary | ||||||
| Current Values: | count | Count_Function | All_Male_Clients | All_Female_Cients | ||
| Changing Cells: | ||||||
| $C$307714 | 0 | 0 | 0 | 0 | 0 | |
| $C$307693 | M | M | M | M | M | |
| $C$307675 | F | F | F | F | F | |
| Result Cells: | ||||||
| $C$307674 | CODE_GENDER | CODE_GENDER | CODE_GENDER | CODE_GENDER | CODE_GENDER | |
| $D$307674 | All Male Client’s for Income | All Male Client’s for Income | All Male Client’s for Income | All Male Client’s for Income | All Male Client’s for Income | |
| $E$307674 | All Female Client’ Loan Amount | All Female Client’ Loan Amount | All Female Client’ Loan Amount | All Female Client’ Loan Amount | All Female Client’ Loan Amount | |
| $C$307675 | F | F | F | F | F | |
| $D$307675 | 109046053233.00 | 109046053233.00 | 109046053233.00 | 109046053233.00 | 109046053233.00 | |
| $E$307675 | 16671718737.00 | 16671718737.00 | 16671718737.00 | 16671718737.00 | 16671718737.00 | |
| Scenario Summary | |||||
| Current Values: | count | Count_Function | All_Male_Clients | ||
| Changing Cells: | |||||
| $C$307714 | 0 | 0 | 0 | 0 | |
| $C$307693 | M | M | M | M | |
| Result Cells: | |||||
| $C$307692 | CODE_GENDER | CODE_GENDER | CODE_GENDER | CODE_GENDER | |
| $D$307692 | All Male Client’s for Income | All Male Client’s for Income | All Male Client’s for Income | All Male Client’s for Income | |
| $E$307692 | All Male Client’ Loan Amount | All Male Client’ Loan Amount | All Male Client’ Loan Amount | All Male Client’ Loan Amount | |
| $C$307693 | M | M | M | M | |
| $D$307693 | 56363959764 | 56363959764 | 56363959764 | 56363959764 | |
| $E$307693 | 524032384717.62 | 524032384717.62 | 524032384717.62 | 524032384717.62 | |