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.
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.
Last edited by Aland2929; 02-09-2012 at 07:43 AM.
Hi,
please see the file attached if it helps
Regards
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
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.
Is it possible to insert a formula in the pivot table that divides a field by the working days in a particular month?
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
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
Maybe it helps=sum(if($A$2:$A$1000>0,if(month($A$2:$A$1000)=month(A2),1/Countif($A$2:$A$1000,$A$2:$A$1000))))
Ciao
You can also find the number of days of a given month usingIf you have a simple table with the number of working days per monthwhere A1 contains a date=day(eomonth(A1,0))
Thanks for your response but I want the working days, not calendar days?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks