Hello,
I have a table of data, the first two columns of which are Date and
Transaction Amount.  What I'm trying to do is put together a table that
will summarize total transactions by month/year.  My goal is to have 1
through 12 (months) as the column headers, and have the years be the
rows.  Then I could use Sum of Transaction Amount as my data field.

However, I can't seem to figure out how (or if I can) force a pivot
table to base both the rows and columns on the same data point.  I've
right clicked on the column headers and selected both Calculated Item
and Calculated Field.  When I try to enter:

=Month(Date) 'where Date is my field name

I get an error that says "References to multiple item names per field
cannot be included in PivotTable formulas."

If it's possible to do this with a pivottable, please let me know.  I
know I can add a two new columns to my underlying data and use them to
calculate the month and year of each individual data point, but that
would change the layout of my table and would require rewriting of some
macros, so I'd like to avoid that if at all possible.

Thanks,
Mike
McKinney, TX