you can create this by using SQL(Choice list value...choose option as SQL results) applying condition error in desc(order by).. this will give you results in decending order.
Hi Ibag Thanks for reply
But i created a Analysis with below Columns
Day, Name, Error_Code, Error_Count
In Compound Layout i created a table and from Columns and Measures list i drag and drop the Day Column in to Table Prompt, here i have to apply the above logic.
Instead of putting Day Column in to Table Prompt, you create it in Prompts Tab and apply SQL as said by Ibag there.
mark if Helps.
Write the sql query like in prompt:
Edit the prompt -> Option -> Default Selection -> SQL Results -> write the below query
SELECT DATE_COLUMN FROM SUBJECT_AREA WHERE MAX(ERROR)
Hope it helps!