Hi,
I'm not sure if this is possible without using programming which would be great, but if not, appreciate if I anyone can assist with the following task:
I have a pivot that has a dynamic inventory code field in the report filter (also is a slicer on the report page for user to select an item from this field) and I wish for this to select the first item by default when the workbook is opened. For now, it currently selects the item that was last selected before the workbook was saved and closed (which could be an issue if the item is no longer available in this field). Is this possible?
Thanks in advance.
Bookmarks