1 Reply Latest reply: Apr 9, 2013 7:45 PM by Yuri Nicolett RSS

    Set Analysis

    Yuri Nicolett

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


      I created a graph with dimension MONTH and PRODUCT, 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 select one month.


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


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



      Follow the example application.


      Thank you!