Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
updating pivot table to include additional rows | Excel Discussion (Misc queries) | |||
pivot table created from another pivot table | Excel Worksheet Functions | |||
Change Data In Pivot Table | New Users to Excel | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) |