0 Replies Latest reply: Jun 24, 2014 9:37 AM by Matte Radencrantz RSS

    AGGR with additional dimension

    Matte Radencrantz

      Hi

       

      In the below aggregation which works well  I also want to add only 'NEW' products (TYPE = "NEW').

      Could someone tell me how would I include also TYPE = 'NEW' in the below aggregation so that it only sums up 'NEW'

       

      =-

      sum(aggr(distinct only(INFPERIOD)='$(vInforceMonth0)',Value))

       

      Thank you!