Sorting by expressions in charts when using inter record functions in attribute expressions
I have been trying to use inter record functions in the attribute expression of a straight chart. The purpose was to exclude the totals row from the formatting. The expression I used to define the background color looks like this:
=if(RowNo()>0 and SomeOtherCondition, RGB(255,0,0))
It seems however that whenever I introduce a chart inter-record function (RowNo() in the example) into an attribute expression, it is no longer possible to sort the table on an expression, but only on dimensions.
Has anyone else experienced this problem? And are there any ideas on how to overcome this?