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.
Did you tried Value Prompts ?
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.
enjoy :)