Know maximum item

[#1]

Dear grus!!

my question is so simple but i m not able to solve it.....

I have created line graph with item_name as dimension and sum(purshase cost) as expression

I have sort this graph decending.

so i am getting one of the item in top (let say computer)

now i want to show/highlight the name of that item (computer) which has highest cost in text box.

what would be the expresion in text box.?

[Anonymous · Accepted solution]

Hm,

One way of doing it, which might be overkill is:

=maxstring(aggr(dual(item_name, sum(PurchaseCost)), item_name))

[#3]

=maxstring({<PurchaseCost={$(=max(PurchaseCost))}>}Item_name)

Regards

Raj

[#4]

thnks for answer its work perfectly fine..... u rocks

[#5]

@arjuun

u also right but it is giving me item having highest purchasing cost did not apply on sum(prucshasing_cost)..

well thans to u also