Pivot Table help required

[syedmahtab]

Hi experts,

I need your assistance urgently. I am working on a task. Please view these 2 images.

https://docs.google.com/leaf?id=0B3...NTlmNGJiNWViNDVk&sort=name&layout=list&num=50

https://docs.google.com/leaf?id=0B3...Yjk0YWY3NjE3MmNk&sort=name&layout=list&num=50

1st image shows my data. This data is about articles submitted by different persons at different times on my website.

Column A has person name, Column B shows date when he/she written the article, Column C shows the time when article was submitted, Column D shows the time spent on article and column E shows article name.

Now, I created a pivot table based on date, person, total time worked, no. of articles. You can see the table in second image.

In pivot table, 'Sum Of Time Spent' shows the total time spent by a person on that date. 'count of Article Name' shows the total no. of articles worked by person. 'Sum of Time min' shows total time spent in hours in decimal.

Now the problem is I want to calculate No. of articles / hour. So, I added a calculated field but it does not work. What I have figured out is that the value from 'Count Of Article Name' is not being fetched in calculated field. Here is what I put in calculated field:

=Article_Name /time_min

But this does not work and a 0 value appears as shown in image.

Is there any expert who can advise me to resolve the issue.

 

[cjcobra]

In your formula, take your article_count and multiply *1. that should put it in a normal number format.

 

[syedmahtab]

In your formula, take your article_count and multiply *1. that should put it in a normal number format.

Thanks for your reply. I did the same i.e.
= Article_Name * 1
and it results 0. Then I tried this one:
= count(Article_Name) * 1
and it results 1.

Another thing to mention is that there is no Article_Count Field, rather it is Count of Article_Name column only as you can see in the image provided. Actual field is Article_Name

 

[syedmahtab]

Hi everyone,

The main problem I am facing is that I am unable to get the value of 'Count of Article_Name' in calculated field. If I could call the value from column D (Count of Article_Name' in formula, then the issue will get solved automatically.

What I think is that the filed 'Article_Name' contains text of articles in it. So, when we use it in formula, it does not provide count. Probably, it is causing the problem. Then I used count(Article_Name) in formula but it also did not solve the issue.

Is there some expert to solve the issue?

Thanks in advance.