I'm sure, I've seen this set up, but can't seem to get it to work. I'm using
Excel 2007 and have inherited a rather complex analysis report based on 3
pivot tables. My current requirement is to include more detailed data for
the report, but this then causes an error that the pivot tables can not
overlap. So, what I'd like to do is have the filters on one sheet and the
actual raw data on another sheet that's hidden (the end user is more
interested in the charts than the raw data, which is hidden on the current
sheet anyway). I'm certain I've seen pivot tables set up like this, but,
naturally, never investigated it too closely, so I could be completely
mistaken.

Is this even possible? And if it is, how do I go about separating the two.

TIA,
Chris