So I have a variable MaxRevenue which gives me maximum of all the numbers in a record e.gSrn Company Revenue 1 ABC 10000 2 XYZ 5000 3
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