first sorted value and aggr

[samuel_brierley]

hi all,

i cant seem to work out why the below wont work

=FirstSortedValue(aggr(sum({$< Area -= {''}>}[Total Emissions]),Area),Area)

basically the aggr creates a virtual table of total emissions grouped by area (this works ive tested it separately). i then want to sort that table such that i return the area with the highest total NOx.

any help is much apprecoated/

thanks

[rahulpawarb]

Could you please share sample application? this will help us to provide expected inputs.

Regards!

Rahul Pawar

[balar025]

Any Sample data or app?

[antoniotiman]

Hi Sam,

maybe this

FirstSortedValue(DISTINCT Area,-Aggr(Sum([Total Emissions]),Area))

or provide sample data.

Regards,

Antonio

[Anil_Babu_Samineni]

I think you missed first parameter

[sunny_talwar]

Try this

=FirstSortedValue({$<Area -= {''}>} Area, -Aggr(Only({$<Area -= {''}>} Area), Area))

[samuel_brierley]

Hi all,

thanks for the suggestions but they dont seem to be working quite yet.

i've attached a sample for your reference.

[sunny_talwar · Accepted solution]

Try this

=FirstSortedValue({$< Area -= {''}>} Area,-Aggr(Sum({$< Area -= {''}>}[Total Emissions]),Area))

[samuel_brierley]

excellent thank you!!!

[sasiparupudi1]

Swap the aggr and area dimensions

FirstSortedValue(Distinct Area,-aggr(sum({$< Area -= {''}>}[Total Emissions]),Area))