Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.?
Hm,
One way of doing it, which might be overkill is:
=maxstring(aggr(dual(item_name, sum(PurchaseCost)), item_name))
Hm,
One way of doing it, which might be overkill is:
=maxstring(aggr(dual(item_name, sum(PurchaseCost)), item_name))
=maxstring({<PurchaseCost={$(=max(PurchaseCost))}>}Item_name)
Regards
Raj
thnks for answer its work perfectly fine..... u rocks
@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