Pivot Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database with type and age ranges in columns. Six age ranges. One
type column. The data (dollars), by type and age range are below each age
range column. I want a summary report that sums the dollars by type and age
combined. My preference is to have the sum of age ranges in the rows, the
type in the columns with the dollar sum of each type and age range in the
data fields. I hope to have the sum of the types for all ages on the right
and the sum of the ages for all types at the bottom. It seems simple enough
but,

I don't seem to be able to make the table work?
 
If the age ranges are in separate columns in the source data, your table
isn't optimized as a pivot table source. Perhaps you could use
Data>Subtotals instead -- sort by type and age range, and sum on the Age
range columns.

To prepare the data for use in a pivot table, you should have one column
for age range, with the age range selected there. Then, in a separate
column, enter the amount.
 
I figured it out. The main problem was to have the data converted to numbers
from text. Text imported from Access. I put the age ranges in the data area
and the type in the column area. The age ranges go in as "count of age
range". I conveted them to "sum of age range", added in a total column to
get the sum at the bottom of the table, added titles, ect and am done.

Thanks,
 
Back
Top