Excel Pivot ability to automatically multiply pivots into new tabs based on field

[newnewbie]

Hi,
Excel experts - evidently, Excel 2003 pivot table had a built in capability to parce out the pivot table into separate tabs based on one field values. E.g. If the pivot table had a region field with 4 regions in it - South, North, East and West - this built in capability allowed you to click on the Region field, etc and Excel would create 4 individual tabs with pivots for South, North, East and West.

I cannot find this feature in Excel 2007 pivots - am I dreaming?

I know I can probably do a macro to do that for me, but if it is a built in feature, I woudl like to find it and use it.

Any ideas woudl be appreciated!

Thanks,
Lena

[newnewbie]

Found the answer! It's under Pivot Table Tools - Options - Show Report Filter Pages!

It is not perfect, as the feature simply copies the pivot into different tabs and applies the filter, but it definitely has a lot of value.

Thank you everybody!
Lena