Pivot Table Trouble; outputting equal numbers despite that not being the case
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.
[link] [comments]
Want to read more?
Check out the full article on the original site