14 Replies Latest reply: Nov 12, 2015 6:15 AM by Sunny Talwar RSS

    FirstSortedValue with  set analysis

    ilan baruch

      hi all,

      I have a straight table (best reps) with 1 dimension and 2 expressions

      dimension is department, and the expressions are:


      1. Rep. Name

      FirstSortedValue(REP_NAME, -Aggr(Sum(AMOUNT),DEPARTMENT, REP_NAME))



      Max ( aggr ( sum ( AMOUNT ), DEPARTMENT, REP_NAME ) )


      I want to add an expression that will sum reps (from expression 1) the quantity  sold,

      by default when I add sum(quantity ) it calculates the dimensions quantity.


      any ideas?