Sorting issue in straight table

[#1]

Hello All,

I have 3 dimensions and 2 expressions in my straight table. I want to put the sorting criteria in all my dimensions and expressions. I have enabled sorting in the Sort Tab but in my table it's only sorting by Pocs.QTY.

Can you help me on this?

Thanks,

Viju

[Gabriel]

Hi Viju,

If I understand you, you want to sort your 3 dimension to your preferred choice.

In your Straight Table go to -> Sort tab -> Select the First Dimension -> Check Expression -> Click on the Eclipse (...) and type in Match(DimensionValue,'Date','Date','Date','Date','Date','Date'). You will have to repeat this exercise 3 time for all your Dimensions.

Hope this is helpful

Best Regards,

Gabriel

[cesaraccardi]

Hi,

Please have a look at the Sort Tab and make sure all the fields have a single sorting criteria selected. Also it would be good to check the Group dimension PeriodDate.Date to see if you have defined sorting criteria for the fields too.

Kind Regards,

Cesar

[#4]

Hi All,

Thanks for your answers but I can't find the solution.

I have attached a qvw in which I have my table. My problem is that I want to sort all the columns in the straight table, that is, to have the small sorting arrow in all the columns.

Can you please check if this is possible?

Thanks.

Viju

[Clever_Anjos]

I can´t see your app, only the picture

[Brice-SACCUCCI]

Hi,

you cannot split a line of data. What result do you expect by sorting all the columns?

If you have this data:

1; 2; 3

2; 3; 1

3; 1; 2

Sorting by column 1 gives:

1; 2; 3

2; 3; 1

3; 1; 2

Sorting by column 2 gives:

3; 1; 2

1; 2; 3

2; 3; 1

Sorting by column 3 gives

2; 3; 1

3; 1; 2

1; 2; 3

You could say : "Sort by column 1, then by column 2" which means "Sort by column 1. If several lines have the same value for column 1, then sort them using column 2".

Regards,

Brice

[er_mohit]

if you want to sorting any field in straight table either dimension side or expression side

then just double click on label field of that particular column

hope it helps