Auto-print Pivot Table Report that cycles through all Page Field values...

T

Tripp Knightly

Suppose I have a pivot report with a Page Field. In my case, it
allows a drilled-down view for a given state using source data
covering all states. Pretty common use case, I imagine.

I'd like to be able to have excel print a multi-page report for all
states (not together, but individually). It should just cycle through
all values of the page-field value.

This seems like a pretty basic thing to want to do with a pivot table
but so far I don't see that it's possible. I mean, sheesh, they even
called it the "page field" as if it's supposed to be part of a
multi-page report.

Thanks for either pointing out where I configure such a report or what
workarounds might be.
 
Top