Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have a pivot table which has a list box called Data Source which will allow the user to choose between Inpatients and Outpatients
However, what I want is 3 buttons across the top so the user can click on a button called -Total(Shows all)
-Inpatients (Shows just inpatients)
-Outpatients (Shows just Outpatients)
Can anyone help me achieve this
Kind Regards
Helen
Hi,
Please find here the attached file for your issue
Hello
Thank you for your reply.....I have copied your technique in a new document by creating 3 buttons, with an action of Apply Bookmark and have added 3 document bookmarks in the menu and assigned these bookmarks to the buttons
I do not know whether I am missing a step, as the buttons in my new document do not seem to be working
So apart from Adding Bookmarks, creating buttons and assigning these bookmarks to the buttons.....Have I missed anything out?
Thanks
Helen
Hi,
Please share the new document you have created.
Apart from this you can assign buttons with clear action also ,so that when you click next button the previous selections get cleared.
Regards,
Udit