Pivot tables, IF statements, vlookups?
 

I'm using Excel 2003. My spreadsheet has 9 Department tabs, each with 10
Funding Source Categories columns and 20 Expense Category rows. Not all the
Departments use all of the Funding Sources or Expense Categories. I have a
Master Pivot table based on all Departments combined: Departments are pages,
Categories are columns, Expense Categories are rows, and data is sum of $. I
want to pull the Expense data from the pivot table within each Department,
based on the Categories actually used by that department, and I want to use
the same formula for each Department's layout (for consistency). I have
copied the master pivot table to each of the department tabs & am showing
that particular department, but since not all pages of the pivot table
generate all the rows or columns, I'm stuck. Any and all assistance would be
greatly appreciated - Thanks!!!

Pivot tables, IF statements, vlookups?
 

Double-click the Row field button
Add a check mark to 'Show items with no data'
Click OK

dannyrblock wrote:
I'm using Excel 2003. My spreadsheet has 9 Department tabs, each with 10
Funding Source Categories columns and 20 Expense Category rows. Not all the
Departments use all of the Funding Sources or Expense Categories. I have a
Master Pivot table based on all Departments combined: Departments are pages,
Categories are columns, Expense Categories are rows, and data is sum of $. I
want to pull the Expense data from the pivot table within each Department,
based on the Categories actually used by that department, and I want to use
the same formula for each Department's layout (for consistency). I have
copied the master pivot table to each of the department tabs & am showing
that particular department, but since not all pages of the pivot table
generate all the rows or columns, I'm stuck. Any and all assistance would be
greatly appreciated - Thanks!!!


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Pivot tables, IF statements, vlookups?
 

Thank you so much, Debra - I've looked at those field buttons over and over,
and just didn't see that! DUH! Now I can use if and isna functions instead
of cut & paste...

Thanks again!

"Debra Dalgleish" wrote:

Double-click the Row field button
Add a check mark to 'Show items with no data'
Click OK

dannyrblock wrote:
I'm using Excel 2003. My spreadsheet has 9 Department tabs, each with 10
Funding Source Categories columns and 20 Expense Category rows. Not all the
Departments use all of the Funding Sources or Expense Categories. I have a
Master Pivot table based on all Departments combined: Departments are pages,
Categories are columns, Expense Categories are rows, and data is sum of $. I
want to pull the Expense data from the pivot table within each Department,
based on the Categories actually used by that department, and I want to use
the same formula for each Department's layout (for consistency). I have
copied the master pivot table to each of the department tabs & am showing
that particular department, but since not all pages of the pivot table
generate all the rows or columns, I'm stuck. Any and all assistance would be
greatly appreciated - Thanks!!!


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html