Forum Discussion

KoroneL's avatar
KoroneL
Frequent Visitor
1 year ago
Solved

Sort by column not possible

I have a table that I want to use to create a report. My goal is to aggregate data by the column DescLvlGroup, which is almost identical to DescCodLvl. The difference is that for aggregation, "Cash" ...
  • bhanu_gautam's avatar
    bhanu_gautam
    1 year ago

    KoroneL Create a new calculated column in your table that concatenates DescLvlGroup and _OrderCodLvl to form a unique value for sorting.

     

    UniqueSortKey = CONCATENATE(DescLvlGroup, _OrderCodLvl)

     

    Use this new UniqueSortKey column to sort your DescLvlGroup column.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Thanks for the reply from bhanu_gautam.

 

Hi KoroneL ,

 

It can be sorted during my test. 

Have you solved your problem? If it is solved, please mark the reply that help you as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster. If there are any more questions, please feel free to let us know. Thanks a lot!

 

Best Regards,
Zhu