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

# 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

• ###### Re: Sorting a Pick Match Dimension

you can sort either using one dimension or one expression

hope this helps

• ###### Re: Sorting a Pick Match Dimension

I have only one dimension i want to sort the dimension as i mentioned

• ###### Re: Sorting a Pick Match Dimension

Hi.

If I understand you right, the problem is with sorting field values and strings simultaneously.

You could try to adopt this trick for dimension:

=Pick(Match(KPI,1,2,3),

dual(text(ActivitiesDesc), fieldIndex('ActivitiesDesc', ActivitiesDesc)),

dual('Perf vs Plan', 0),

dual('% of NetSales', 100000))

Then just use sort by numeric value.

• ###### Re: Sorting a Pick Match Dimension

Hey whiteline nice Superb! i got it exactly how i want but for the text (means Perf vs Plan and % of net Sales) i have to give different color can u help me in solving this

• ###### Re: Sorting a Pick Match Dimension

If you expand the plus sign to the left of your expression or dimension, you'll see Background Color and Text Color. There you can write an expression to colorize the cells.

For example, to assign different colors for 'text' and ActivitiesDesc you can use:

=if(Match(KPI,1,2,3)=1, blue(), green())

• ###### Re: Sorting a Pick Match Dimension

Thanks a lot