Skip to Content
0
Former Member
Sep 29, 2016 at 09:21 AM

How to select records matched with a variable?

12 Views

So I have a variable MaxRevenue which gives me maximum of all the numbers in a record e.g

Srn Company Revenue 1 ABC 10000 2 XYZ 5000 3

PQR

500

.

So I add a variable MaxRevenue as =Max(Revenue)

But In report I just want to see the record which has the Max Revenue.

which is row 1 above

how do I do that? sorry I am a newbie in WeBI Reports