Sort the Concat function with 2 dimension

[Anonymous]

As we have sort the values of concat function with 1 dimension

Concat(DISTINCT RawDim, '|',Rowno)

Can we this using two dimension

I tried  this

Concat(DISTINCT RawDim, '|',Rowno)

but this gives incorrect result

[jonathandienst]

Is Rowno a field name? Or do you mean RowNo()?

It would be much easier to help you if you provided more details. Its hard to diagnose and fix "incorrect result". The best would be a small qvw file containing sample data and the chart/table that illustrates the problem, along with the output you want.

[tresesco]

You can actually write an expression for sort order, like:

Concat( Distinct SalesMan, '|' , Year*100+Num(Month))