Create a pivot table, by region by item. Put Rep in Page Filter area. Use "show pages" to create one new worksheet for each rep. Please please show every step on what you click and did on excel.

 

Transcribed Image Text:

Region 5 North 6 North 7 North 8 South 4 Rep John Item Date Sales X100 1/1/04 501 John Y200 1/14/04 444 Sally X100 1/27/04 509 Susan Y200 2/9/04 1,234 3,456 South 10 South 11 South 12 North 13 North 14 North 15 South 16 South 17 South 18 South 19 North 20 North 21 North 22 South 23 South 24 South 25 South 26 North 27 North 28 North 29 South 30 South 31 South 32 South 33 North 34 North 35 North 36 South 37 South 38 South 39 South 40 North 41 South 42 South 43 South 44 South 45 North 46 South 9 Susan Y200 2/22/04 Susan X100 3/6/04 2,454 Jim X100 3/19/04 3,245 John X100 3/27/04 501 John Y200 4/4/04 444 Sally X100 4/12/04 509 Susan Y200 4/20/04 1,234 Susan Y200 4/28/04 3,456 2,454 3,245 Susan X100 5/6/04 Jim X100 5/14/04 John X100 5/22/04 501 John Y200 5/30/04 444 Sally X100 6/7/04 509 Susan Y200 6/15/04 1,234 Susan Y200 6/23/04 3,456 7/1/04 2,454 3,245 Susan X100 Jim X100 7/9/04 John X100 7/17/04 501 John Y200 7/25/04 444 Sally X100 8/2/04 509 Y200 1,234 3,456 2,454 3,245 Susan 8/10/04 Susan Y200 8/18/04 Susan X100 8/26/04 Jim X100 9/3/04 John X100 9/11/04 501 John Y200 9/19/04 444 Sally X100 9/27/04 509 1,234 3,456 Susan Y200 10/5/04 Susan Y200 10/13/04 10/21/04 2,454 3,245 Susan X100 10/29/04 11/6/04 Jim X100 Sally X100 509 1,234 3,456 2,454 3,245 Susan Y200 11/14/04 Susan Y200 11/22/04 Susan X100 11/30/04 Jim X100 12/8/04 Sally X100 12/16/04 509 Susan Y200 12/24/04 1,234 Region 5 North 6 North 7 North 8 South 4 Rep John Item Date Sales X100 1/1/04 501 John Y200 1/14/04 444 Sally X100 1/27/04 509 Susan Y200 2/9/04 1,234 3,456 South 10 South 11 South 12 North 13 North 14 North 15 South 16 South 17 South 18 South 19 North 20 North 21 North 22 South 23 South 24 South 25 South 26 North 27 North 28 North 29 South 30 South 31 South 32 South 33 North 34 North 35 North 36 South 37 South 38 South 39 South 40 North 41 South 42 South 43 South 44 South 45 North 46 South 9 Susan Y200 2/22/04 Susan X100 3/6/04 2,454 Jim X100 3/19/04 3,245 John X100 3/27/04 501 John Y200 4/4/04 444 Sally X100 4/12/04 509 Susan Y200 4/20/04 1,234 Susan Y200 4/28/04 3,456 2,454 3,245 Susan X100 5/6/04 Jim X100 5/14/04 John X100 5/22/04 501 John Y200 5/30/04 444 Sally X100 6/7/04 509 Susan Y200 6/15/04 1,234 Susan Y200 6/23/04 3,456 7/1/04 2,454 3,245 Susan X100 Jim X100 7/9/04 John X100 7/17/04 501 John Y200 7/25/04 444 Sally X100 8/2/04 509 Y200 1,234 3,456 2,454 3,245 Susan 8/10/04 Susan Y200 8/18/04 Susan X100 8/26/04 Jim X100 9/3/04 John X100 9/11/04 501 John Y200 9/19/04 444 Sally X100 9/27/04 509 1,234 3,456 Susan Y200 10/5/04 Susan Y200 10/13/04 10/21/04 2,454 3,245 Susan X100 10/29/04 11/6/04 Jim X100 Sally X100 509 1,234 3,456 2,454 3,245 Susan Y200 11/14/04 Susan Y200 11/22/04 Susan X100 11/30/04 Jim X100 12/8/04 Sally X100 12/16/04 509 Susan Y200 12/24/04 1,234

Answer rating: 100% (QA)

Select the cells you want to create a PivotTable from Select In... View the full answer