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.
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.