Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
you can sort either using one dimension or one expression
hope this helps
I have only one dimension i want to sort the dimension as i mentioned
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.
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
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())
Thanks a lot