FirstSortedValue inside Set Analysis for an Expression

[#1]

I only want to avg the number of cat_favor_points for my favorite cat, which is determined by who has the most cat_favor_points.  I cannot seem to get this expression to resolve.

avg({<cat={"='$(=FirstSortedValue(cat,cat_favor_points))'"}>} cat_favor_points)

The FirstSortedValue does work in a text box on its own: ='$(=FirstSortedValue(cat,cat_favor_points))'

[sunny_talwar · Accepted solution]

Try this:

=Avg({<cat={"$(=FirstSortedValue(cat,cat_favor_points))"}>} cat_favor_points)

[#3]

awesome that worked thank you!  always get a little confused on the semantics

[sunny_talwar]

They indeed are very confusing and drives me crazy sometimes.

Best,

Sunny