1 of 1 people found this helpful
You will need to use a separate worksheet as the source for your parameter. Since the parameters are based on worksheet data, if you filter the data on the source sheet then you will only get filtered data in the parameter. Create a new worksheet that is not being filtered by the parameter and use that instead. If you want you can hide the source sheet by making it 1 by 1 pixel.