A drop down/parameter could be used if the data was all in the same source. However, since it is two different sources and it's the dimensions that want to be changed, this option will not work.
One possible option would be to use actions. I have reattached your workbook showing this.
Hope this helps!
Thanks, this helps a lot!