Hello
Hope somebody can point me in the right direction. I have created a pivot table that organizes project data. There is a field Project time which contain the amount of time booked to a particular project and by who. I have created a calculated field =IF('Project Time'>=25, 1, 0) this produces a 1 for people who have booked more than 25 hours to a particular project. However this field isn’t totaled like other calculated fields. Under the total I just get 1. Am I missing something or can anybody suggest an alternative solution.
This pivot table is run from a VBA macro and analyses weekly data, I can’t add the formula to the source because this distorts the summary data .
Regards and thanks
Hope somebody can point me in the right direction. I have created a pivot table that organizes project data. There is a field Project time which contain the amount of time booked to a particular project and by who. I have created a calculated field =IF('Project Time'>=25, 1, 0) this produces a 1 for people who have booked more than 25 hours to a particular project. However this field isn’t totaled like other calculated fields. Under the total I just get 1. Am I missing something or can anybody suggest an alternative solution.
This pivot table is run from a VBA macro and analyses weekly data, I can’t add the formula to the source because this distorts the summary data .
Regards and thanks