Challenge

Project 2 - Create a report using PowerQuery, Macro VBA, List Functions and Data Validation functions for Data Reporting of Supply Chain Management companies

Filtering Data:

Use the filter function to extract rows that match a specific condition. In this case, you want to filter rows where the gender is female ("F").
Assuming your "AMT_INCOME_TOTAL" is in column D and "AMT_CREDIT" is in column E, and your "CODE_GENDER" unique values are in column G (starting from G2), you can use the following formula to filter and sum the income for female clients: =SUM(FILTER(D2:D, B2:B="F"))
Similarly, you can use a similar formula to sum the loan amount for female clients: =SUM(FILTER(E2:E, B2:B="F"))

https://drive.google.com/drive/folders/1nJrkFu2ZRlKZ0PtWrQH_8vyYs8-UYNmI?usp=drive_link

Ship work like this
in your own course.