Sum Fields in Pivot Table

Question

I have a document with Column A (Date) and Column B (Hours). I created a Pivot Table on another sheet, and it's doing an okay job of showing the data:

What I would like it to do is SUM the hours, so it looks like this:

How can I do this?

Doug Glancy · Accepted Answer · 2014-06-06 03:21:16Z

2

Move the hours from being a Row field to a Value field:

enter image description here

answered Jun 6, 2014 at 3:21

Doug Glancy

27.5k6 gold badges72 silver badges118 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Doug Glancy Over a year ago

Note: If you really need the hours to be in the same column as the dates, that will require some trickery, at best. I'm not sure it's possible.

Tyler V. Over a year ago

Thanks Doug. I am noticing that these tables don't update when I change the original data. Can these not keep running sums?

Doug Glancy Over a year ago

Pivot tables need to be refreshed. There's a lot of data cached behind the scenes, and you wouldn't want it refreshing automatically. Just hit the refresh button.

Collectives™ on Stack Overflow

Sum Fields in Pivot Table

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related