Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Name | Sort order | Sales Amount | Symbol |
Mike | 3 | 13000 | $ |
Jim | 3 | 400 |
|
Robert | 3 | 200 |
|
James | 4 | 16000 |
|
Robert | 4 | 700 |
|
Jack | 5 | 14000 |
|
Kevin | 5 | 1000 |
|
Description of the issue:
We want to add a dollar symbol “$” sign at the 13,000 as it is the highest amount in the lowest sort order #
how can I do this??
You can try this expression in the straight table:
=If(SortOrder = Min(TOTAL SortOrder) and [Sales Amount] = Max(TOTAL <SortOrder>[Sales Amount]), '$')
Dimension
Name
SortOrder
Or script option:
1)
Table:
LOAD Name,
SortOrder,
[Sales Amount]
FROM
[Book1 (8).xlsx]
(ooxml, embedded labels, table is Sheet2);
Left Join (Table)
LOAD *
Where RecNo() = 1;
LOAD SortOrder,
Max([Sales Amount]) as [Sales Amount],
'$' as Symbol
Resident Table
Group By SortOrder
Order By SortOrder;
2)
Table:
LOAD Name,
SortOrder,
[Sales Amount]
FROM
[Book1 (8).xlsx]
(ooxml, embedded labels, table is Sheet2);
FinalTable:
LOAD *,
If(RowNo() = 1, '$') as Symbol
Resident Table
Order By SortOrder, [Sales Amount] desc;
DROP Table Table;
Didn't we just got this resolved here: Display '$' symbol to only highest sales amount on condition.
I'm not having access to that Community...can you pls provide the solution here
You can try this expression in the straight table:
=If(SortOrder = Min(TOTAL SortOrder) and [Sales Amount] = Max(TOTAL <SortOrder>[Sales Amount]), '$')
Dimension
Name
SortOrder
Or script option:
1)
Table:
LOAD Name,
SortOrder,
[Sales Amount]
FROM
[Book1 (8).xlsx]
(ooxml, embedded labels, table is Sheet2);
Left Join (Table)
LOAD *
Where RecNo() = 1;
LOAD SortOrder,
Max([Sales Amount]) as [Sales Amount],
'$' as Symbol
Resident Table
Group By SortOrder
Order By SortOrder;
2)
Table:
LOAD Name,
SortOrder,
[Sales Amount]
FROM
[Book1 (8).xlsx]
(ooxml, embedded labels, table is Sheet2);
FinalTable:
LOAD *,
If(RowNo() = 1, '$') as Symbol
Resident Table
Order By SortOrder, [Sales Amount] desc;
DROP Table Table;
Thank you very much