Recent content by Vorbeck
-
V
Order By ascending if negative, descending if positive
X would be from another query. I used a query to rank the results on absolute terms, then I want to, one by one, display the top drivers for the top 3 ranked results (i.e. in 3 different queries). This issue is, using the Top Values depends on the sort order, so I need the sort to be ascending... -
V
Order By ascending if negative, descending if positive
Hi, I am wondering if there is a way to incorporate an IIF statement into a Order By statement. I am trying to set up a query so that when X>0, field Y sorts descending but when X<0 field Y sort ascending. For context, I am trying to show the top 5 absolute values, and the top drivers of those...