creating a pivot table in Excel: need help

%3CLINGO-SUB%20id%3D%22lingo-sub-779910%22%20slang%3D%22en-US%22%3Ecreating%20a%20pivot%20table%20in%20Excel%3A%20need%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-779910%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20create%20a%20pivot%20table%20by%20following%20this%20instruction%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CEM%3E%22Create%20a%20Pivot%20Table%20on%20a%20new%20sheet%20where%20the%20row%20label%20is%20%22troop%22%20and%20the%20value%20is%20the%20count%20of%20troops.%22%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20was%20able%20to%20create%20the%20pivot%20table%20by%20selecting%20the%20%22troop%22%20column%20from%20the%20main%20sheet.%20However%2C%20the%20instruction%20did%20not%20specify%20where%20to%20find%20the%20%22count%20of%20troops%22%20value.%20Do%20I%20need%20to%20set%20the%20formula%20for%20%22count%22%20on%20the%20main%20sheet%20first%2C%20or%20is%20this%20something%20I%20should%20do%20within%20the%20pivot%20table%20itself%3F%20Thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-779910%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-779929%22%20slang%3D%22en-US%22%3ERe%3A%20creating%20a%20pivot%20table%20in%20Excel%3A%20need%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-779929%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F384533%22%20target%3D%22_blank%22%3E%40excelquestion%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELooks%20like%20homework.%20It's%20within%20the%20PivotTable%2C%20check%20for%20example%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.excel-easy.com%2Fdata-analysis%2Fpivot-tables.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.excel-easy.com%2Fdata-analysis%2Fpivot-tables.html%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I'm trying to create a pivot table by following this instruction:

 

"Create a Pivot Table on a new sheet where the row label is "troop" and the value is the count of troops."

 

I was able to create the pivot table by selecting the "troop" column from the main sheet. However, the instruction did not specify where to find the "count of troops" value. Do I need to set the formula for "count" on the main sheet first, or is this something I should do within the pivot table itself? Thanks!

1 Reply
Highlighted

@excelquestion 

Looks like homework. It's within the PivotTable, check for example https://www.excel-easy.com/data-analysis/pivot-tables.html