I have a prompt which lets the user select different UK cities e.g London, Manchester, Birmingham etc.
I want a line under the citites that says UK, this will then give me a seperate line in the output list for UK with the consolidated values of all the cities.
Is this possible? Can I define what is included in UK?
You can add a static choice to the prompt which will be shown in the dropdown list. By setting the use value to a proper high integer (say 999999) and sorting the data for the prompt query it will appear at the end.
Your data query should then either select values related to a city or fetch all data:
example:
[citykey] = [?city_key?] or [?city_key?] = 999999
Thanks for the reply, I understand what you mean and it worked.
One other thing. Righjt now, If I have a static selection of UK, it gives me all the cities that make up the UK. I want one line that gives me the aggregated values of the UK.
So for example, If I select UK and Birmingham in my multi-select prompt, I get one line for Birmingham and one line for UK.
Is this possible?
Sure, use a union. Set 1 covers the selection for individual cities and set2 fetches all data in case the static prompt value is among the chosen values. In set 2 replace the city description by the fixed value 'UK'