Can I Conditionally create a report with prompt values

[N013]

Hello all,

Is there a way to create a query based on user input? My requirements are to have a user select two years to compare (More than likely current & previous) and then select a period (ex January, February...) then display the difference.

[the_xxx]

Did you tried Value Prompts ?

[N013]

I have figured this out out. I set up a value prompt and created an expression to check for which value was selected. Then I render the column based on the value prompt the user selected.

[the_xxx]

enjoy  :)