I have a dataset that has (1) time period (month) as one of the columns, and (2) multiple additional columns that include different metrics. I’m trying to create a pivot table that has time period for columns, and the other additional metrics listed vertically with their total values for each period populated in the table. So if I had a dataset that has the columns: Family Name, Year, # of Dogs, #of Cats, # of Fish… I want a table that has year for the column headers, and I want the rows to be Dogs, Cats and Fish - with the annual totals for each listed in the table. Hope that makes sense. I can’t figure out how to make a visualization that does that.
It sounds like you’re on the right track by using a pivot table! If you pivot by year, and use Dogs, Cats, and Fish as dimensions, does that get close to what you’re trying to achieve? What is still missing?