2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Pivot Table Trouble; outputting equal numbers despite that not being the case

An example of what a behavioral interaction unit's result looks like, alongside column categories. There are 1535 total rows to this data sheet.

The current pivot table I am working with. Not only does it have every behavior using the same number, it also has a higher Grand Total than I have rows in my datasheet (1535).

The current setup for my pivot table.

Hey all,

I'm looking to create a pivot table to help me count how many of a set of animal behaviors were observed in some videos. My initial spreadsheet has dropdowns for the sex of the individual (male, female, female with pup, unknown), dropdowns for who is the "sender" and who is the "receiver" (some include 'both' for spontaneous starts), and dropdowns for the presence or absence of each behavior. There's also drop downs for no instances of aggression within our subsamples (to separate out the "didn't happens" from the "no interactions").

The problem comes when I try and create a pivot table that counts how many of each behavior happened with each sex; interactions for female senders x male, female, female with pup, and unknown receivers, and so on. The pivot table itself uses the same counts for each behavior, even though every interaction did not involve all of the same behaviors; while it may be a coincidence that a given behavior is exhibited the exact same number of times, all of them being the same number across the columns for every single row is giving me pause and is making me think I did something wrong.

Is there any way I could make this pivot table work (this is my first time trying one out)? Would there be a better solution to my problem? Thanks in advance!

Quick edit: I am in Excel 2021.

submitted by /u/RnbwTurtle
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#natural language processing for spreadsheets
#financial modeling with spreadsheets
#rows.com
#Excel compatibility
#real-time data collaboration
#Excel alternatives
#big data management in spreadsheets
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#conversational data analysis
#row zero
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications
#automation in spreadsheet workflows
#intelligent data visualization