I have two prompts in a dashboard.
The first one is of City which list all of the Cities in US. The prompt has the feature to select multiple cities.
The second one is a list of Shops located in different cities.
The dashboard shows the sales and profit based on the selection criteria.
I require that if the user selects 'New York' in the first list, the second list should be short listed to the list of shops in that city instead of all the shop.
How I can achieve this functionality.
I have developed multiple prompts for my dashboard based on individual columns and attach filters to these prompts.
To use the feature you mentioned; I have to develop one single prompt with all the selected columns. How I can now attach this prompt to the report for the filters ? (so that I then use prompt + report in the dashboard).
How can I now attach the prompt to the report?
The reports I developed don't have those column which I use in the prompts. In my current scenerio I develop filters in those reports and then attach individual column prompts to these filters so when I attach the reports in the dashboard; the prompts works.
When I develop one constrained prompt with multiple column; what is the way I attach this prompt to the report?