View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Yossy Yossy is offline
external usenet poster
 
Posts: 127
Default Pivot table Help Excel 2007

Is there a way I can Hide some data in Pivot table.

I have 3 Rows of column that I pivot but I want only one row to show without
anyone having access to the filter option in the "Value field setting Menu".
I use Excel 2007 please all help totally appreciated.

Also can I put 2 pivot tables in one worksheet? Please let me know if I can
and how to do this.

Thanks a Big Bunch.