3 Replies Latest reply: Apr 14, 2015 12:58 PM by Jonathan Poole RSS

    Why is there a need to specify the same set expression twice?

      Why do I have to specify the same set expression ( {<Year={2012}>} ) twice? First time for sum() and second for max().


      =Max({<Year={2012}>} aggr (sum( {<Year={2012}>} Sale),Company_Name,Product))


      Initially I though there would be enough to state it for sum, so that only the rows for 2012 would be passed on to the max().


      I have taken the example from:

      http://www.analyticsvidhya.com/blog/2014/02/aggr/

      The blogger states that the expression is needed twice, but unfortunately not why.