Sorting Issue

[Anonymous]

Hi All,

can you help me on the below sorting issue.

I have a table with Order & 3 different prices details as below.

Order	Price1($)	Price2($)	Price3($)
A	3	2	1
B	2	4	3
C	8	6	7

the desired output is the prices should sort for each order as shown below.

Order	Price1($)	Price2($)	Price3($)
A	1	2	3
B	2	3	4
C	6	7	8

Looks like simple but not able achieve, can you please help.

[MK_QSL]

How to source data ?

Can you provide source data ?

[Anonymous]

Please find the sample data. Source is excel files with static prices per order, there won't be any change once we receive the data.

[MK_QSL · Accepted solution]

Use below in script

CrossTable(Price,Value)

Data:

LOAD Order,

     [Price1($)],

     [Price2($)],

     [Price3($)]

FROM

Community_297434.xlsx

(ooxml, embedded labels, table is Input);

Now use

Dimension

Order

Expressions

Max(Value,3)

Max(Value,2)

Max(Value,1)

[Anonymous]

Thanks !!

It's working