2 Replies Latest reply: Feb 22, 2013 12:59 AM by Hennie Welman RSS

    Get period with max sales

    Hennie Welman

      Hi, I have a straight table with Period, Sum(Sales). I want to display the period with the maximum sales in a text box. If I use max(Aggr(sum(Sales),Period)) I get the maximum sales value so how can I get the period which that value belongs to?

       

      Thank you

       

      Hennie