Home

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
excelquestion
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

@excelquestion 

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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies