Pivot Table Question
I have the following portion of a pivot table from some Excel data. I would like to take the Month sum value (which is 15 for Jul) and divide by the number of date entries (which is 13 for Jul). Essentially the average number of entries per entry day. Is there a way to create that calculation within the pivot table?
Jul151.153-Jul1 5-Jul1 7-Jul1 10-Jul2 11-Jul2 12-Jul1 18-Jul1 20-Jul1 21-Jul1 24-Jul1 25-Jul1 27-Jul1 31-Jul1
I have the following portion of a pivot table from some Excel data. I would like to take the Month sum value (which is 15 for Jul) and divide by the number of date entries (which is 13 for Jul). Essentially the average number of entries per entry day. Is there a way to create that calculation within the pivot table? Jul151.153-Jul1 5-Jul1 7-Jul1 10-Jul2 11-Jul2 12-Jul1 18-Jul1 20-Jul1 21-Jul1 24-Jul1 25-Jul1 27-Jul1 31-Jul1 Read More