pivot Table Group

  • Thread starter Thread starter george
  • Start date Start date
G

george

How can I group all of these into like a Month. So that I can take
everything that happened
in January and sum it up. Each one of these would have a dollar amount
attached and we
keep track of the whole year.

What I want to do is show the total by month. So basically I want to select
January and have
a total or sum of all the accounts that happened during that month. How do
I group all the
days together so that I only have to choose January as the month.

01/01/04 Balance Forward
01/02/04 ADP Fees
Block
Mary
Bromptons
Philip
Barry
Reger
VOID CK #18427
VOID
Returned Ck - K. Klein
01/05/04 Mary
Clarence
Health
Donald
VOID CK #20064
VOID
01/06/04 Mary
Lancaster
Patty
McCullough
NYS
George
RP I
Seneca
Seneca
Laura
Cobra
Fund
Catering
TRS
Advertising
James
Bauer
Boltz
5452 BWL
01/07/04 Joe
Matthew
 
Hi George,

I am not too sure that I understand your question, but usually you would
need a column with the date to be able to group data by date (or month).

Try my Pivot Table tutorial at http://edferrero.m6.net/tutorials.html for an
explanation of grouping, filtering etc.

Ed Ferrero
 
Back
Top