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))

       

      2. SALES AMOUNT

      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?