good morning David
here is the calculation
if [Number]%[Selected Number] = 0 then 'yes' else 'no' end
it returns this
the calculation is Mudolo and this will explain how to use it
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Thanks for the quick response, Jim. However, this doesn't address the issue I'm having. I have already been using modulo in my "Set 1" definition in order to highlight the proper multiples when I set my Selected Number parameter manually.
However, the issue I'm having is that I really don't want that Selected Number parameter to exist at all. It only exists because I don't have the solution I need.
I actually just want the user to click on a bar, and then the multiples of the clicked-on bar will be highlighted.
Since this problem appears to be intractable, let me ask the question in a different way:
Is there any way to capture the value of a single mark that I highlight, such that I can create a dynamic set that is based on the value of that highlighted mark?