1
1
How can I conduct the following calculation in pivot table? Sum the Total Hours and divide it by the sum of the Ticket Count for each Year-Month. Here's a snapshot of my spreadsheet.
The output would be something like:
If I use the Average function in the Pivot Table option, it would just average the total count of the data occurrence, not the sum of the Ticket Count.