In the older versions of excel, you could select "Where is the data that you
want to Analyze" as "another pivottable report or chart report" Now I don't
have that option in 2007 excel. There is only a place to select a
table/range or use an external data source.

How can I use the current pivot table that I just made to make another pivot
table report.

thanks.