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.