Filter query output based on key figure
We have a requirement to filter query output based on key figure.
When a query is executed, the query should only display list of orders for which the amount1 is greater or equal to amount2. out of the below record in infoprovider, only record 2 and 3 should be displayed in output.
Please let us know how this can be achieved in query designer. Thanks
|Order No||Amount 1||Amount 2|