2 Replies Latest reply: Jun 25, 2013 12:15 PM by Gysbert Wassenaar RSS

    Maximum value of all data

    Dieter Himmel

      Hello,

       

        

      Max(Aggr(SUM({<STOFF_KZ={'L'}>}SALES)/SUM(SALES), COMPANY,MONTH

      ))

       

      I have this expression which returns the maximum quota of leather sales per month and company for my current selected period.

      Now I want to have the maximum quota for the whole period although I have selected only one month.

      How can I solve this problem?

       

      This expression e.g. returns the maximum date of all dates although I have selected only one month.

       

      Max({$<MONTH>}DATE

      )

       

       

      How can I combine this two expressions?

      Thanks for your help. 

       

      Dieter