ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Display all pivottable filter selections (https://www.excelbanter.com/excel-worksheet-functions/208108-display-all-pivottable-filter-selections.html)

AudKen

Display all pivottable filter selections
 
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 somewhe
Filtered by: Region = Northern, Southern; Book Type = A, B.




All times are GMT +1. The time now is 04:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com