How do I show Pivot Table "Totals"

[Les Williams]

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

 

[lozzablake]

to only get totals you have to move any fields in the rows section (ie column headers only)

 

[Les Williams]

Hi Blake
Thanks for your response
Can you explain a little more clearly
Thanks
Les

 

[lozzablake]

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

 

[Les Williams]

Thanks Pal - I think I've got it.
Much obliged