I have attached a Sample look at it.
You can achieve this by many ways I have explained 2
1. I have created a Button which you can click and get the default Selection.
2. I have set Clear mode even by Default if you click on Clear it will give you same output.
I suggest you to create a Button and for respective you can also use
- Sheet Triggers,
- Chart message when user select a Date then only it should appear else a Message.
hope this help you
Demo.qvw 156.2 K