Using firstsortedvalue

Anonymous — Thu, 30 Apr 2015 10:43:25 GMT

Hi,

I am using firstsorted value in a textbox.

When I do:

=FirstSortedValue(producto, -aggr(sum(venta),producto))

it works and I get the value P2 , now I want to know the sales of product P2:

=sum( { <producto={P2}> } venta )

But when I use that expresion:

=sum( { <producto={( =FirstSortedValue(producto, -aggr(sum(venta),producto)))}> } venta )

It doesn't work....

I don't know what is wrong, can anybody help me?

Thanks,

Re: Using firstsortedvalue

sunny_talwar — Thu, 30 Apr 2015 10:45:32 GMT

Try it like this:

=sum({<producto = {"$(=FirstSortedValue(producto, -aggr(sum(venta),producto)))"}>} venta)