two conditions in one sum dimention

[#1]

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

[jagan · Accepted solution]

Hi,

Try this expression

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

Regards,

Jagan.

[#3]

thank you very-very much !