Display all pivottable filter selections

A

AudKen

In an Excel 2007 pivottable over MSAS with multiple filters, I have users
making multiple selections. When they print, they only see "Multiple
Values". I can't seem to find anything that shows how to display all
selections made on one filter. Optimally we would like the ability to
display everything filtered on and what those selections are in like the
footer or some specified cell of the "report".

Example, display somewhere:
Filtered by: Region = Northern, Southern; Book Type = A, B.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top