please check the below links.
You can achieve this using parameter. Here I've used supersstore data and created a string parameter with empty current value.
Follow the screen shots:
Create a parameter like this
Then link this parameter in a calculated field. Now show parameter control and drag the calculated field in your worksheet.
Enter the Order Id and press enter. It'll returns the sale of that particular Order.
Let me know If this help.
Thank you for your response, but this doesn't allow me to input multiple values. Also, this is just filtering the data but I want based the input values the relevant data should be loaded from database.