You could use the Show Pages feature to create a pivot table on a
separate sheet for each operator --

Move the Operator field to the page area.
Then, select a cell in the pivot table, and from the PivotTable toolbar,
choose PivotTable Show Pages.
Select Operator in the list, and click OK.

ak wrote:
I create a pivot table with the field "Operator", "item", "Order No" as row
field , "Month" as Column field and "Order No" as Data Field. Is there any
way that the data can be separated into different sheet by "Operator"?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html