So, I am creating several reports for answers not dashboard.. With these reports I am supposed to come up with prompts that will enable users to be able to make several selections. In the dashboard I know I can create a sql statement that will condition the report. I am just not sure how can I create a table prompt with such conditions. For instance If I have a pivot table, how do I condition its prompt
Does anyone has an idea on how to condition and use report prompts in answers?