Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
i've got an issue where first sorted value can be multiple values
=FirstSortedValue([name], -Aggr(sum( {1} [countid]), [year], [name] ))
and in pivot table by year for name i get "-" because there are multiple names with the same sum...
How can I fix this?
How do you need? Perhapd this way
=FirstSortedValue(Concat(distinct [name], ','), -Aggr(sum( {1} [countid]), [year], [name] ))
Hello @Anil_Babu_Samineni yes probably something like that, but this expression doesn't work. Gives error like "nested aggregation isn't allowed".
Thanks though 🙂
can you share sample application where we can demon the same?