Pivot Table Selections
 

Hi All,
I have a table in an excel spreadsheet with the following fields

Month (1-12)
Account
Location
Department
Actual
Budget

Using this data, I have created a Pivot table with the Month and Department
in the "Page" area, the Account in the row area, and Actual and Budget in
the Data area, with a calculation in the data area to calculate variance.

This works great because the user can select a month and department and get
month information for that department.

Now I would like to give them the ability to select year to date for any
year to date during the year, not just the current month (i.e. current
period is July, but they want Jan-May). Also, because this table is used
for another report that prints the annual budget, I can't limit the table to
just periods 1-x, I have to have all twelve periods in the table.

Any suggestions would be appreciated ---

Rich Mogy

Pivot Table Selections
 

in the source data use a dummy column (with a formula) to specify whether to
include the row or not. Then use that field in your pivot table.

--
Regards,
Tom Ogilvy

"Richard Mogy" wrote in message
...
Hi All,
I have a table in an excel spreadsheet with the following fields

Month (1-12)
Account
Location
Department
Actual
Budget

Using this data, I have created a Pivot table with the Month and
Department
in the "Page" area, the Account in the row area, and Actual and Budget in
the Data area, with a calculation in the data area to calculate variance.

This works great because the user can select a month and department and
get
month information for that department.

Now I would like to give them the ability to select year to date for any
year to date during the year, not just the current month (i.e. current
period is July, but they want Jan-May). Also, because this table is used
for another report that prints the annual budget, I can't limit the table
to
just periods 1-x, I have to have all twelve periods in the table.

Any suggestions would be appreciated ---

Rich Mogy