Pivot table calculation question

[jb00976]

I have a pivot table that looks like this

Row Label Appointment Email Phone Call
Joe 148 302 86
Kate 129 88 303
Ron 157 398 157
Paul 125 221 47

I want to have a column between each of Appointment, Email and Phone call that divides the count for Appointment Email or Phone Call by 48 (number of weeks in the period I am looking at).

My fields are setup as follows
Filters - none
Columns - "Activity Type"
Rows "Modified By"
Values "Count of Regarding"

I think I need a calculated field but, can't figure out the formula. Please help

Thank You
Jen

 

[XavierXcel]

You need to make 3 calculated fields each with the value field divided by 48.

If you are trying to divide the count of the value field by 48. easy way is to add 3 columns in your data set using a If function to return zero or one. and use those fields in the pivot table calculated field function and divide by 48.

I dont think count as a function works well in the calculated field. (ie. =count(field)/48)

you can also make your pivot table a dynamic table by "offset" and "name" function so you can add more columns in the future without the need of creating new pivot table.