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

    Calculated field to return the highest value

    Samuel Gee

      Hello!

       

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

       

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

       

      So:

       

      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

       

      Sam