Aggr function used for dimension

[#1]

I am using an aggr function for an item dimension.  It basically checks to see if the qty shipped (NO_UNITS) is not equal to zero, because I only want to see items that meet this criteria.

Well I have another criteria I need to add to this & I'm not sure how I would write this out.

I also need to not have any items that begin with the letter 'B' to be included in the set.

Is it possible to do this?????

Here's the function that I have so far:

=aggr(if(sum({<FYEAR={$(vCompYr)},QUARTER={$(vCompPrd)}>}(NO_UNITS))<>0, ITEM),ITEM)

[Gysbert_Wassenaar]

Try: =aggr(if(sum({<ITEM={'B*'},FYEAR={$(vCompYr)},QUARTER={$(vCompPrd)}>}(NO_UNITS))<>0, ITEM),ITEM)

[#3]

This gives me all the items that begin with 'B' and I need items not beginning with 'B' and qty shipped <> 0

If I do <> I don't get any items to display

[sunny_talwar · Accepted solution]

Then try this:

=aggr(if(sum({<ITEM -= {'B*'},FYEAR={$(vCompYr)},QUARTER={$(vCompPrd)}>}(NO_UNITS))<>0, ITEM),ITEM)