Generate pivot tables across sheet using page field

[RJ2DJ]

Hi guys,

I've tried searching for this, but can't find the answer - it's probably to do with the way I'm asking, so I'll explain it as clearly as I can.

I am trying to find out if there is a way of creating pivot tables (one per sheet), for each and every item I have in my page field.

For example. If my page field contains [All, Monday, Tuesday, Wednesday Thursday, Friday] and underneath I have rows with pupils and columns with subjects and results.

I have my main pivot table on the front sheet that shows [All] their results combined. What I would like to generate (automatically) is 5 sheets (Monday-Friday), which would give me a breakdown by day.

I hope I've explained that clearly - the actual data I have is not days of the week, and contains about 35-40 page fields - hence why I don't want to set it up manually and refresh each time!

 

[RJ2DJ]

Found the answer:

http://www.mrexcel.com/tip135.shtml

The trick is to use "Show Pages" option on the Pivot table drop-down menu - hope this helps someone.