• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

PIVOT TABLE

Q

quyogacu

New Member
I am creating an effort logger pivot table to calculate the total no. of hours spent on a specific project but pivot table returns the no. of cell instead of actual sum.
I also tried changing the value formula from count to sum but still it does not works.
And
there is a blank field with entries in it which are not actually present in the raw data table
It also counts 1.5 as 1 but i want it to count it as 1.5.
 
quyogacu
As a new member, please reread Forum Rules

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...
chandoo.org
especially How to get the Best Results at Chandoo.org
.. and soon You'll remember - at least - what is missing from Your tread?
 
You must log in or register to reply here.
Back
Top