Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have the following expression in pivot table
this part of expression works nice : aggr( max(List), Article)
but complete expression doesn't work:
=min( { < List = {$(aggr( max(List), Article))} > } value1)
am I doing anything wrong? can anyone help me please on this?
thanks in advance,
CAFC
I think your forgot the = before the aggr.
=min( { < List = {$(=aggr( max(List), Article))} > } value1)
I think Paul is correct about the "=" but the expression also does not seem logical to me.
aggr( max(List), Article)
returns a set of max(List) values. Which value should be used as the List = modifier. All of them?
-Rob
the solution for my pb is simply...max(value1)...
thanks anyway