Sort depending on prompt selection

[jethrothul]

Hello,

is there a way of making the sorting of a report depend on the selection made in the report filter prompt ? For example a report has the metrics turnover and profit with a prompt filter to choose whether the Top n customers based on turnover or profit should be displayed. Is it possible that the report be sorted based on the selection made ?

Thanks for your help

 

[Z3]

Sure, but this is going to be tricky because you will need to modify the Web code - basically add an IF statement says for report_id so and so then check the prompt answers before sending it and add sorting in URL depends on the prompt answers. Probably 2-3 days of consulting work. It'd be a nice enhancement request - I'd log it with the support to make sure they do some work for you.