I have a chart that has a cyclic dimension, most of these dimensions are items such as region, country, fund type etc which should be sorted by value in descending order (Y-Value Descending), however, one of the dimensions is a Year Purchased and when this dimension is active we want to sort in Year order.
Does anybody know how I can do this in a sort expression (i.e. IF ( DIM='Year' , YearNumber , Y-Value )
Note: I cannot put the expression itself into the statement above because the expression is a cyclic one.
The problem is that when you set up a cyclic group on EXPRESSIONS, there is no group name so you cannot access the group and therefore cannot use the GetActiveField or GetCurrentField functions.
To be honest, I have always avoided this issue by separating series that are "Y" sorted from those that are ordinal sorted into different charts. I normally have a practice of using Bars for the former and Lines for the later anyway so it makes sense to me.
