I work a lot in Excel, but haven't done calculated field work before. Essentially, I need to take a populated column in a pivot table, in this case it's a count of whatever by hour of day. So rows is the hour of the day and the data is the count of customers by hour. I need to add a column to take that total number of customers by hour and divide it by 91, because I ran the data for a 3 month period. It absolutely has to be part of the pivot table because I'm trying to create a dynamic graph that can be pivoted and updated. I attached a simple copy paste and formula of how I did it without the calculated field.
What I'm struggling with most is what the formula is within the calculated field to say take the field from the main column of the pivot table and divide it by 91.