Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to sort by expression instead of default options available in the chart. Is there a way to do it?
Whenever I use two measures the sorting stops working and shows random behavior.
Can you share some examples to understand the problem better?
Here you go.. I have attached an example where in I want to sort by sum(Sales Amount). But its not allowing me to do so.
Thanks.
Utkarsh,
You are using above and rowno which are inter record functions and sorting is disabled inter record functions
see here
Sorting on y-values in charts or sorting by expression columns in straight tables is not allowed when chart inter-record functions are used in any of the chart's expressions. These sort alternatives are therefore automatically disabled.
and here
When I use the Above() function, doesn't permit to order values. Why?
Is there a way to do this?