limit prompt values based on the analysis result

Summary:

Is there a way to limit my prompt values based on the analysis result

Content (required):

Ex - for the Status prompt I don't want to see retired as a value, as there are none of the records below with status retired..

I want the Prompt Values to be dynamic based on the analysis result.

is this achievable ??

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):