Hi Tracy -
THANK you so-o much for taking the time to set up the example response. This was a great exercise for me in many ways -taught me the power of the parameter control which I have been slow to adopt for my own work - as soon as someone shows me where it fits I can see, yes, this is exactly what I was looking to do...So thank you for that extra insight.
I was able to set my own worksheet along the lines you've instructed, however the percent of sales looks to be showing the percent of the total company sales, and not percent of Region - the product (in my case clients) are part of a region, and I wanted to get the clients sales as a percentage of Region's sales.
Yesss! it works now!
so I think I needed to have the Percent of Sales calculated prior to setting the Parameter control maybe? because after setting the control I was not able to correct its "Table (Down"" or "Table (Across)" etc. feature, or/and somehow it was not recognizing the Region as its partition - so I switched to a % field I had previously calculated and it works fine with that field. Feels very precarious though, as if I have to continuously monitor that it doesn;t slip off to another partition (additionally I am tracking this across 5 years).
But I will continue to work with this.
So again THANK you!!! It works as intended.