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!