How do I show Pivot Table "Totals"

Les Williams

New Member
Joined
Aug 2, 2006
Messages
24
I've developed a Pivot Table from an Excel database. I'm trying to run a report that shows total lbs, total made, total time etc for each product code run in a particular month. I'm getting the individual monthly details for each time the product was run in the month but I can't get "just" the totals. Any help would be greatly appreciated.
Thanks
Les
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

lozzablake

Well-known Member
Joined
Dec 15, 2005
Messages
818
to only get totals you have to move any fields in the rows section (ie column headers only)
 

lozzablake

Well-known Member
Joined
Dec 15, 2005
Messages
818
If you choose Layout option (right click on table choose Wizard and then Layout) you see a grid with areas for Column,Row,Data and Page. If you just want totals for the columns you must have no items in rows. If you just want totals for the rows you must have no items in columns. If you just want totals and nothing else no items in either columns or rows.

You must always have at least one item in data
 

Forum statistics

Threads
1,141,756
Messages
5,708,333
Members
421,566
Latest member
7Nabisco

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top