I am trying to calculate the true average call duration per day. Any time I use the Average function on the pivot table, it comes up wrong. For example the true Average of July 1st is 1:51but the pivot table says it is 2:01.
InkedCapture_LI.jpg
I am trying to calculate the true average call duration per day. Any time I use the Average function on the pivot table, it comes up wrong. For example the true Average of July 1st is 1:51but the pivot table says it is 2:01.
InkedCapture_LI.jpg
HOW TO ATTACH YOUR SAMPLE WORKBOOK:
Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks