11 Replies Latest reply on Aug 18, 2015 8:25 AM by Samuel Gee

    Calculated field to return the highest value

    Samuel Gee



      I have 200 titles, each with sales across 300 weeks.


      I would like to see the highest week's sales, per title.




      Title 1     Week 43     17,000

      Title 2     Week 21     14,321

      Title 3     Week 52     13,481


      I'm sure there's some sort of calculated field that would let me do this easily, but I'm having trouble working out what to use. I tried with MIN and MAX and dabbling with an Index, but none of it really achieved much.


      All advice very sincerely appreciated