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

    two conditions in one sum dimention

    Dmitry Lapchenkov



      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