6 Replies Latest reply: Nov 5, 2012 3:54 AM by Swetha Kolluru RSS

    Sorting a Pick Match Dimension

      Hi

       

      I have a chart with dimension as Pick(Match(KPI,1,2,3),ActivitiesDesc,'Perf vs Plan','% of NetSales')

      and few expressions as Pick(Match(KPI,1,2,3),Sum(Sales),expr for PerfvsPlan,expr for % of Net Sales)

       

      Here ActivitiesDesc is a FieldName

       

      I want to sort my dimension in the chart as

       

      ValueofActivitiesDesc,

      'Perf vs Plan',

      Value of ActivitiesDesc,

      .

      .

      .

      .

      '% of Net Sales'

       

      pls suggest