Need to add a custom row to a prompt - Use macros?

[thedon_1]

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?

[blom0344]

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

[thedon_1]

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?

[blom0344]

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'