Hi All,
I have a dashboard prompt whose selection is limited to its previous prompt and it should also sort in descending order.
Prompt1: Region Name (Can, Ind, UK,..)
Prompt2: Can 2003
Ind 2017
UK 2012
Can 2007
Prompt 2 should sort by Year in descending order. However when I try using SQL Results I don't get Limit Value by option.
Can any one please help on how to achieve Sort as well as Limit value by previous prompt ?
Thanks,
LonaD