topic Re: Sorting two level column in App Development

Sorting two level column

MoxieMeister — Sat, 16 Nov 2024 19:28:29 GMT

Hi all,

I have some problems with sorting in the column name levels.

My try is:

But necessary make like this:

Cannot swap columns level.

Is it possible?

Thanks.

Re: Sorting two level column

Anismohamed32 — Thu, 12 Dec 2019 12:52:15 GMT

Hi ,

You can sort the column at your own wish , by having if condition in the sorting tab.

1. click the sort option
2.write if condition by selecting the option set by expression.
3. if condition example :
=if(group='M27',1,
if(group='Axis',2,
if(group='Black',3,
if(group='GSC',4,
if(group='T3',5,
if(group='TDM,6,7)

Re: Sorting two level column

MoxieMeister — Thu, 19 Dec 2019 10:28:25 GMT

Hi,

The basic idea of sorting is to ignore the sorting of the first header.

In this case, test data is presented. In the original, data is added dynamically.

Accordingly, this 'If' does not universal approach.

Thanks.

Re: Sorting two level column

Anil_Babu_Samineni — Thu, 19 Dec 2019 10:34:11 GMT

Try this as a Sort by expression

Match(Group, 'M27','Axis','Black','T3','TDM')

If not, Create Mapping field in the script with some serial no to form same as that field