Filter

[spividori]

Hi.

I have the following application:

Where the total Vta Product C is 4.

When I selected the Prove R, I need the total of Vta remains 4.

I use the following expression: Sum({<Prove= >} CantVta), but it shows me all the products and you should see the products Prove R.

The result should be next:

Attached the example.

Regards.

[#2]

Hi,

Try this

Sum({<Producto={'C'} ,Prove=>} Cpra),

[spividori]

This is an example, the products can be one or more in my real application.

Regards.

[spividori]

HI,

Any idea ?, help please.

Regards.

[jagan · Accepted solution]

Hi,

Try this expression.

=Sum ({<Producto=P({$<Producto>}), Prove= >}CantVta)

Regards,

Jagan.

[spividori]

Hi.

Thanks for responding.

I modified your expression as follows: sum( {$<Producto = P({$} Producto), Prove = >} CantVta)

When I select a Prove that had several products, when I select a product showing all products of this Prove.

This way allows me to filter the products also.

Regards.

[jagan]

Hi,

If you got the solution please close this thread by giving correct answer to the useful post.

Regards,

Jagan.