Project 2 - Create a report using PowerQuery, Macro VBA, List Functions and Data Validation functions for Data Reporting of Supply Chain Management companies
unique,sort,filter functions are not working in my excel
I have created new sheet named as Q.2.1 and from this new sheet i have decribed the data summary through the
pivot table
the Actual steps
- =UNIQUE(array,FAlSE,FALSE)
- =FILTER(Table1[TOTAL_INCOME], Table1[CODE_GENDER]="F")
- =FILTER(Table1[AMT_CREDIT], Table1[CODE_GENDER]="F")
- and next apply sort function
the remaining answers are attached below