5 Replies Latest reply: Oct 10, 2012 11:02 PM by Ramkumar Ramagopalan RSS

    Need an intersect with setanalysis

    Ramkumar Ramagopalan

      I want to display the top 10 players for the value Mat/Inns ( Mat divided by Inns)

       

      I tried something like this to start with but doesn't seem to work (no surprise, I'm a novice)

       

      =if ((Mat/Inns)=max(Mat/Inns), Player)

       

      Please help.

       

      Thanks

      Ram