Set Analysis Question

[aaronnayan]

Hi Guys,

Really quick

i have a KPI :

max(aggr($(vMargin),[CustomerName]))

Which gives the value £

I want to get the Name 'String'of the customer with the most Margin?

Thanks

[aaronnayan]

i can confirm this was the result

No Max was needed!!!

=firstsortedvalue([Customer Name], -aggr($(vMargin),[Customer Name]))

[vishsaggi]

Try this?

= Firstsortedvalue([CustomerName], -aggr(RangeSum(sum({<SInvoiceCount = {1}>} [Marginlcc]), sum({<SCreditC = {1}>} [Marginlcc])), [CustomerName]))

Also check when you use this variable in a textbox are you seeing any value?

Once you confirm you are seeing values. We can implement using variable. Let us know.

With variable try like

= Firstsortedvalue([CustomerName], -aggr($(vMargin), [CustomerName]))