4 Replies Latest reply: Apr 10, 2013 2:08 PM by Yuri Nicolett RSS

    Help with Set Analysis - MAX

    Yuri Nicolett

      I have a table with MONTH, WEEK, DAY, PRODUCT and VALUE

       

      I created a graph with dimension MONTH and PRODUCT, in expresson I need the VALUE of the biggest day of the month. (This value will be used to perform other account)

       

      Problems encountered: When do the set analysis to catch the biggest day of the month, he does not respect the month dimension. Only respect when I selected.

       

      Expression used: SUM({$<DATA = {$(=max(DATA))} >} VALOR)

       

      I've tried to use AGGR, but had no success.

       

       

      Follow the example application.

       

      Thank you!