I'm taking note of the amount of time I spend studying certain subjects. Each row in the table is one study session and I may have multiple study sessions per day. The Pivot Table sums everything in the column. The mean and st dev are over the number of instances.
Screenshot.jpg
Is there a way to calculate the total number of minutes spent per day, mean daily minutes, and daily st dev in one pivot table?
Screenshot001.jpg
I've tried making a pivot table with the dates as row labels then changing the grand total but that requires three tables for each subject (one for total, one for mean, and another for st dev). (Manually calculated file attached.)
Bookmarks