Excel 2007 creating reports for diffrerent products one at a time
 

Help!
I created a pivot table from an OLAP cube to show net sales and other
information for all products in a department. I added the product code
and department code to the report filter to allow me to filter on a
product or a department. Then I converted the pivot table to formulas,
formatted the report. and now I want to use this report going forward
to distribute to different departments every week. The problem is I
can't filter on department code (neither product code)from within the
report. Any help will be appreciated.

Thanks, Rima

Department Code 003
Product Code All

Net Sales Retail Retail Year Retail Week
2008
Department Product Primary Size 2008 W1 2008 W2
003 - Men's Knits 00301-0013 - L/S SMU THRML XL
00301-0023 - L/S PLAQUET L $14.98 $65.06
00301-0024 - L/S MOD SLUB XL $25.06
00301-0026 - L/S PCE FNGRS L $25.85