Forum Discussion
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" ...
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.
bhanu_gautam
Super User
Super UserKoroneL 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.