3 Replies Latest reply: May 28, 2010 10:31 AM by juergm RSS

    Sort by Expression - User selection for chart

    Christian_Henke

      I want to give the user the chance to decide whether he wants to sort by a calculated value or by the Dimension.

      Therefor I created a Variable SortBy (Value;Name)

      And use the expression:

      if( SortBy = 'Value',

      min(

      if( CompFact > 0,

      PRICE / ER_EUR / MP.CONV_F * CompFact,

      PRICE / ER_EUR / MP.CONV_F

      )

      ),

      PRICE_CHART_LABEL

      )

      If I use the min() function alone it works. Using the dimension name as expression (here PRICE_CHART_LABEL) doesn't work. Neither the combination as shown above.

      Any idea how to implement a user selection for sorting by expression or by dimension ?

      Thanks in advance