How to add Subquery in where clause in Report
I have a report which needs a Subquery in where clause. But i am not able to find such option in Filter advanced settings.
Below example query will give me the seconds highest value for Group Transfer. Can you tell me how i can create Report using this condition.
selectMAX(Group_Transfers) from hpd_help_desk
where Group_Transfers < (select MAX(Group_Transfers) from HPD_Help_Desk)