16 Replies Latest reply: Apr 17, 2014 7:55 AM by Manish Kachhia RSS

    aggr function

    ekaterina bolotova

      Hi.I faced a problem.

      1.png

      I have tw fields Subregion and Product. Expr  is

       

      cout({$<CalendarYearQuarter={'2013-Q1'}>} distinct CustINN ) 

      In total we see 3362. How to write expression which will calculate this total sum in front of every product.

      What I would like to get is

      1.png

      This   expression   aggr( sum(Expr),Subregion  )   doesn`t work.