I have a table in which i have some fields. I have a date column which has multiple dates . just need to fetch last 2nd date for respective dimension. Using set analysis we can do it in front end..i need this in script. attached is the sample QVW and sample screen shot.
For Australia 2/3/2016 is the max date which is showing. i need 5/3/2016 which is 2nd largest date.