Hide data in pivot table?

[Alan]

I am using XL 2002, I am working in a faily simple pivot table that
identifies sales for customers by month [sum of month is in the data
field]. What I want is simply the sum of the month, as opposed to
seeing each months data listed, followed by the sum. This way the
report wont be 500 pages as well!

Any help is appreciated!

Alan

 

[Dave Peterson]

Remove all the fields except for that date from the Row field????

And group that date field by month and year.

I am using XL 2002, I am working in a faily simple pivot table that
identifies sales for customers by month [sum of month is in the data
field]. What I want is simply the sum of the month, as opposed to
seeing each months data listed, followed by the sum. This way the
report wont be 500 pages as well!

Any help is appreciated!

Alan

 

[Alan]

The filed I want to keep is the sum field, which you cant select from
the drop down for that field. It is the sum I want to keep and the
months I want to lose.
ACEY DECY EQUIPMENT CO INC
kill this >> 10/1/2005 $259.14
kill this >> 1/1/2006 ($73.58)
kill this >> 2/1/2006 $102.00
KEEP THIS SHURE Sum $3,342.09

 

[Dave Peterson]

Did you remove everything from the row field except for the customer name and
the date field name?

And if you right click on that date field icon, you can choose to group by month
and year.

 

[Alan]

David -

That was it - a couple of clicks and my problem was solved.
Thanks....and I thought I had looked everywhere.

Alan