1 Reply Latest reply: May 21, 2014 10:05 PM by Sergey Makushinsky RSS

    Show amount for max day in a month

    Robin Cushman

      Hi all,

       

      I have the following dataset, and in a straight table I'm trying to list out the month (as dimension) and the amount corresponding to the max day of each month as the expression.

       

      LOAD * INLINE [

          Month, Day, Amt

          1, 1, 5

          1, 2, 6

          1, 3, 2

          2, 5, 8

          2, 6, 9

          2, 7, 4

          3, 8, 11

          3, 9, 3

          3, 10, 2];

       

      So for month 1, the Amt value would be 2 (corresponds to day 3, which is the max day of month 1), for month 2 the Amt value would be 4, for month 3 the Amt value would be 2.  If I'm using Month as dimension, what would I use for the expression to show the correct amount for each month?  I suspect I should use set analysis and AGGR and the Only() function, but I haven't been able to figure out the right combination.

       

      Thanks very much!

       

      Robin