Using firstsortedvalue

[Anonymous]

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,

[sunny_talwar · Accepted solution]

Try it like this:

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