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!