2 Replies Latest reply: Nov 9, 2012 8:32 AM by Dmitry Lapchenkov RSS

    two conditions in one sum dimention

    Dmitry Lapchenkov

      Hi

       

      Tell me please who know, can i use something like this:

       

      Aggr(sum({<year={"2012"},id=>} sum({<bg_t={'*'},id=>} Quantity_i)),AffiliateID, Id,mes)

       

      in field whith expression i need to sum Quantity_i by 2 conditions:

       

      1. Only 2012 by year

      2. Only bg_t that is not null