Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
How to source data ?
Can you provide source data ?
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.
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)
Thanks !!
It's working