I'm able to assign values to prompted filters, for example to prompt for a specific client. But it seems there's no way to similarly prompt for something that gets used in a variable sense, rather than a grandiose filter for the entire result set.. Thanks for your help

I appreciate the help. Can you point me in the right direction? I have two columns measures, each pointed to a particular year. This year and last year. I have a prompt where the user inputs a year, and both columns correctly calculate the year based on that prompt How can I do this through a scheduled agent? A repository…