Display "(Multiple Items)" in the Pivot Table's Report Filter

When you select more than one item as the Report Filter, it's displayed as (Multiple Items).

For example,

- When you select a single item, "A" from the list of available filters "A, B, C", it would display "A".
- When you select more than one items, "A, B", it would display "(Multiple Items)".

Challenge
Is there a method to display the actual values of these items, then (Multiple Items). In the example given, it would show "A, B" instead of "(Multiple Items)".

Thank you.

There's some VB code you can use to build a string of the selected items and show them in the cell next to the filter. You'll need to know sheet name, pivot table name, filter field name and possibly hard code where you want the list to appear.

I took another tack here. I made it a function so you can use it in other places as well. The syntax is ShowList (SheetName, PivotTableName, FilterName).

If you are using Excel 2010, you could use the slicer feature to control your pivot table. Click inside your pivot table, click on the Options contextual tab, then select insert slicers. You can then pick which fields you want to add slicers for. Using the spreadsheet from dflak's post, I modified to use slicers instead of the VBA.

Good thought. I prefer non-VBA solutions when I can implement them. Even though they are essentially filters, slicers look really impressive.

I found the function was very helpful with standard pivot tables, however it did not work with a cube. Does it need to be modified for that situation?

I am trying to list the "multiple" values selected in a pivot filter. The original function code did this for a regular pivot table, but not one based off a cube. While I am not familiar with the built-in CUBE functions suggested, unless I am missing something, I am not seeing how either will provide the results I am looking for.

Thoughts??