Hi team

[#1]

HI Team
could anyone help me..

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:

1. 1.       Name
2. 2.       Sort Order
3. 3.       Sales Amount

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??

[sunny_talwar]

Didn't we just got this resolved here: Display '$' symbol to only highest sales amount on condition.

[#3]

I'm not having access to that Community...can you pls provide the solution here

[sunny_talwar · Accepted solution]

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;

[#5]

Thank you very much