Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
May be try this:
Sum({<REP_NAME = {"=FirstSortedValue(REP_NAME, -Aggr(Sum(AMOUNT), DEPARTMENT, REP_NAME))"}>}Quantity)
did not work
: (
Like below!!
Max (aggr (sum ( Quantity ), DEPARTMENT, REP_NAME ) )
try like:
=sum({<REP_NAME={'*'}>} quantity)
hi , it gives me the dimension quantity (department),
I need the reps quantity from expression 1
Change the dimension, take REP_NAME as Dim and Expression wud be =sum(Quantity)
hi,
thank you for your effort,
this Expression retrieve the max quantity of the department, I need the quantity of the rep in Expression 1
Hi,
Is it not similar to what Tamil suggested, just replace the max with sum
sum(aggr (sum ( Quantity ), DEPARTMENT, REP_NAME ) )
Mark
Then try with Sum instead of Max (Mentioned by Mark).