Aggr function to simply group by

[#1]

Hi,

Is there a function which simply groups by a field by a key. Like I want to group by sales by item code.

I don't want to sort out min/max value

I want to do something like [Value] - AGGR(Min([Value]), [ITEMCODE])

So all the values corresponding to an item must display 'x' units less if 'x' is the minimum sales value for that item.

How do I make sure that the [Value] field is grouped by the item code, because if I just use the above simply, my expression errors out...

I want to achieve this in the front end and not the script.

Thanks..

[MK_QSL]

[Value] - AGGR(Min(TOTAL <ITEMCODE> [Value]), [ITEMCODE])

[#3]

thank you so much Manish, Could you suggest what would be the expression when we have two keys to aggregate upon?

[MarcoWedel]

Do you require to display this in a chart?

What are your dimensions?

[Anonymous]

we use below expression to aggr on two keys:

[Value] - AGGR(Min(TOTAL <ITEMCODE> [Value]), [ITEMCODE],Fieldname)

replace fieldname with your dimension/field

Hope this helps.

Regards

Neetha

[#6]

yes, in a chart and this expression is itself my calculated dimension.. along with itemcode as the second dimension..