Adding a count to pivot table

%3CLINGO-SUB%20id%3D%22lingo-sub-2963990%22%20slang%3D%22en-US%22%3EAdding%20a%20count%20to%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2963990%22%20slang%3D%22en-US%22%3E%3CP%3EHello-%3C%2FP%3E%3CP%3EI%20have%20a%20varying%20number%20of%20the%20same%20library%20programs%20that%20happen%20each%20month.%20I%20made%20a%20Pivot%20Table%20that%20shows%20me%20the%20sum%20total%20of%20attendance%20at%20each%20type%20of%20program%20per%20month%20but%20I%20would%20also%20like%20to%20see%20how%20many%20times%20that%20program%20happened%20in%20a%20month.%20So%20if%20family%20storytime%20happened%204%20times%20in%20January%20and%202%20times%20in%20February%20I%20would%20have%20context%20for%20the%20difference%20in%20attendance%20numbers.%20I%20am%20new%20to%20Pivot%20tables%20but%20can't%20seem%20to%20find%20a%20way%20to%20see%20this%20information.%20I%20do%20know%20I%20can%20click%20on%20any%20value%20and%20see%20what%20data%20was%20used%20to%20get%20that%20but%20I%20was%20hoping%20for%20something%20all%20in%20one%20table.%20Thanks!%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22DMeininger_0-1636929743738.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F326984i9ED6D6BFC5974157%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22DMeininger_0-1636929743738.png%22%20alt%3D%22DMeininger_0-1636929743738.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2963990%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello-

I have a varying number of the same library programs that happen each month. I made a Pivot Table that shows me the sum total of attendance at each type of program per month but I would also like to see how many times that program happened in a month. So if family storytime happened 4 times in January and 2 times in February I would have context for the difference in attendance numbers. I am new to Pivot tables but can't seem to find a way to see this information. I do know I can click on any value and see what data was used to get that but I was hoping for something all in one table. Thanks!

DMeininger_0-1636929743738.png

 

1 Reply

@DMeininger Drag the "Program" field into the values area of the pivot table. Since it contains texts, Excel will default to Count.