Sorting_Expression

[#1]

Hi,

I have to sort my table on the basis of the expressions. And after sorting i have to show only the top 20 values of the expression along with the Dimensions.

Please helppppp!!!!

[#2]

Hi Manish,

Please have a llok on the attached file.

Hope it helps.

Regards,

Yaseen

[nagaiank]

You can specify this in the Dimension Limits tab of the chart properties.

A sample application is attached.

[#4]

Hey in this application there is no sorting at all on the basis of expression

[#5]

I used below expression

IF(Domain ='Sales',1,
IF(Domain ='COGS',2,
IF(Domain ='Marketing',3,
IF(Domain

='Amortization',4,5)))

[#6]

hey in your report Top 5 expresisons are sorted as 400,200,300,800,500.But i want that they should be sorted as 800,500,400,300,200.

[#7]

Then uncheck expression from Sorting.

Use Dimension limits.

For all dimensions dont ckeck any option.

[#8]

here is the attached sample data application. Pleasetell how to sort

[#9]

Please find attached doc.

[#10]

here the partial sum which it's showing is of all the rows not of the top 5