Pivot Table calculation

[Aland2929]

I would like to calculate in a pivot table, the number of calls per day based on the calendar days in the month. I have attached a sample file.
Thanks in advance.

[canapone]

Hi,

please see the file attached if it helps

Regards

[Aland2929]

I don't think you understood what I am trying to do but thanks for the response. In my pivot table report, Mike did 62 calls in Jan & 34 calls in Feb. If there were 22 working days in Jan & 21 working days in Feb, then the calls per day would be 62/22 & 34/21. This is what I want to calculate in the pivot table? The formula is the total number of calls in the month divided by the working days.

[Aland2929]

Is it possible to insert a formula in the pivot table that divides a field by the working days in a particular month?

[Aland2929]

Is it possible to insert a formula in a pivot table that divides a field by the working days in a month?
Month: Calls Calls/Day
Jan 75 =75/22
Feb 60 =60/21
Thanks in advance

[canapone]

Hi,

I would not use a calculated field, but some helper columns in your database.If you have a simple table with the number of working days per month, a Vlookup is sufficient to have first helper column.

In the example attached I calculate the number of working days in a different way.

I've used array formulas to calculate the days when Mike or Susan answered the customers

Please Login or Register  to view this content.

Maybe it helps

Ciao

[Pepe Le Mokko]

If you have a simple table with the number of working days per month

You can also find the number of days of a given month using

Please Login or Register  to view this content.

where A1 contains a date

[Aland2929]

Thanks for your response but I want the working days, not calendar days?