Pivot Table Calculated Field subtotals

Tolle

New Member
Joined
Aug 21, 2019
Messages
7
I am working on a pivot table based on data that has a region, a sub-region, dates, and then the available work potential in each sub-region by date.

I need to do two things,
1. I need to create a calculated field based on the available work potential
2. I need to change the subtotals to be averages not sums.

I can do both, however when I change the subtotals to be averages, not sums, the subtotals for the calculate field becomes blank. Why does this happen? And what can I do to make it not blank? I need to know what the averages of this calculated field by region and sub-region.
 

Forum statistics

Threads
1,082,615
Messages
5,366,616
Members
400,906
Latest member
incanus

Some videos you may like

This Week's Hot Topics

Top