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

    Sorting a Pick Match Dimension



      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



      'Perf vs Plan',

      Value of ActivitiesDesc,





      '% of Net Sales'


      pls suggest