The Excel file "Datasets.xlsx" has the following spreadsheets: - tblAvail01 - tblConstruction - tlkpEthnicity - tlkpGend
Posted: Thu Jul 14, 2022 2:18 pm
The Excel file "Datasets.xlsx" has the following spreadsheets: - tblAvail01 - tblConstruction - tlkpEthnicity - tlkpGender - SF Accounts - tblShortToLong 1. By using tblAvail01, create a pivot table to count the total number of all records where " C " value is −1 in the following format: a. Use Ethnicity and Gender from tlkpEthnicity and tlkpGender accordingly for EthCode and Gencode values.