18 Replies Latest reply: Jul 24, 2018 11:52 PM by Fawaz Abdul Azeez RSS

    How to use firstsortedvalue in a dimension

    Quy Tran

      Hi all, this is my first post.

      Need help trying to limit a dimension. I have created a chart and limit the chart to only show sales people in the top volume region.

       

      I can find my top region by using =FirstSortedValue( region , -aggr( count(ordernumber), region ) )


      But i don't know how to limit this to only show sales people in the top region. any help would be appreciated.