I have created a simple pivot table with a field in the Report Filter section
When I select nmore than one item to filter oon on the default text "(Multiple Items)" is displayed.
As the List contains 200+ items it is a bit of a pain scroling through to see what has been checked.
Is there a bit of code someone has written that will display in say Cell A1 that will list all the checked items.
Any other ideas welcome.
Martin
When I select nmore than one item to filter oon on the default text "(Multiple Items)" is displayed.
As the List contains 200+ items it is a bit of a pain scroling through to see what has been checked.
Is there a bit of code someone has written that will display in say Cell A1 that will list all the checked items.
Any other ideas welcome.
Martin