Hi,
In my pivot table I have a calculated field that gives me a % value for each person month by month ie productivity divided into the hours worked. I use the pivot table data to work out averages using this formula :={AVERAGE(IF(B8:F8>1%,B8:F8))}
see below my pivot table
Team (All)
Sum of RTE % Month
Name January February March April May Average
Person 1 110.8% 131.5% 147.6% 119.7% 122.8% 126.5%
Person 2 117.8% 121.7% 138.2% 112.3% 96.7% 117.4%
Person 3 75.6% 94.9% 136.1% 108.5% 106.5%
Person 4 0.0% 0.0% 0.0% 105.4% 133.3% 119.4%
Person 5 107.9% 113.0% 120.6% 105.3% 106.1% 110.6%
the average values at the moment are not part of my pivot table, I'd like to use the above formula to add this field into the table - but it seems that I cant do this ?
I need to add this into the pivot table to produce some ranking - visual, to see who tops the list and who's bottom.
any ideas on how I do this .... if its possible?
In my pivot table I have a calculated field that gives me a % value for each person month by month ie productivity divided into the hours worked. I use the pivot table data to work out averages using this formula :={AVERAGE(IF(B8:F8>1%,B8:F8))}
see below my pivot table
Team (All)
Sum of RTE % Month
Name January February March April May Average
Person 1 110.8% 131.5% 147.6% 119.7% 122.8% 126.5%
Person 2 117.8% 121.7% 138.2% 112.3% 96.7% 117.4%
Person 3 75.6% 94.9% 136.1% 108.5% 106.5%
Person 4 0.0% 0.0% 0.0% 105.4% 133.3% 119.4%
Person 5 107.9% 113.0% 120.6% 105.3% 106.1% 110.6%
the average values at the moment are not part of my pivot table, I'd like to use the above formula to add this field into the table - but it seems that I cant do this ?
I need to add this into the pivot table to produce some ranking - visual, to see who tops the list and who's bottom.
any ideas on how I do this .... if its possible?