@Leon - I believe you can do it using parameters. Please go through the following link where a similar problem statement has been resolved. you can apply the same technique in your pivot table use case as well. Hope this helps!
2 Likes