Hi,
I have a requirement, where I am showing the highest, 2nd highest, 3rd highest and worst value across a dimension (Date) and based on the selected time period. Now I also need to show the dates for when the above values correspond. This is all done on the UI and not the load script due to data restrictions.
Can someone please suggest a way to achieve this? Example shown below:
Type Date Amount
A 04-May 200
A 05-May 100
A 04-MAY 50
A 05-May 300
B 04-May 50
B 04-May -10
So the result will be:
Type Highest Highest Date 2nd Highest 2nd Highest Date
A 300 05-May 200 04-May
