Excel 2010 – Pivot Table Totals at Bottom

Topic

New Reply

I am summarizing data in a Pivot table and it is adding the numbers but puts the totals for each set of data at the top of that set of data as opposed to the bottom.

How do I change this?

example:

total 6
day1 1
day2 2
day3 3

Thanks!

Reply | Quote

Replies

Not in front of 2010 just now but in 2007, you right-click the field, choose Field Settings, then on the Layout and Print tab uncheck the ‘Display subtotals at the top of each group’ option.

Reply | Quote

Rory, the path you describe doesn’t work in 2010. Other ideas welcome.

Reply | Quote

I just fired up a VM with 2010 on it and the steps are exactly the same.

Reply | Quote

I right click in one of the data fields and it brings up a menu that contains “value field settings.” This is the only thing close to what you say above.

When I do, it only has 2 tabs:
1. Summarize values by
2. Show values as

I am doing something wrong???

Reply | Quote

You need to click on the row field, not the data field.

Reply | Quote

Ok… did and unchecked the box but still showing totals at top. Do I have to refresh (tried) or what to update?

Reply | Quote

No, no need to refresh. Sounds like you did the wrong field – I suspect you wanted to do the row field a level up from the one you did.

Reply | Quote

Forgot to mention, on the Design tab of PivotTable tools, there’s a Subtotals dropdown – you can use that to set all totals to the top or bottom.

Reply | Quote

Perfect!

Thanks.

Reply | Quote