Expression based on dimension that is not in a chart

[Anonymous]

Hi,

First of all, I'm a rookie in QV.

My problem is that I can't write a formula, that would count number of items that had sales less than 500 Eur per period.

So, I tried to write IF(SUM(Sales_amount)<500, Count(Distinct(item)).

The thing is that my chart contains not items (as dimension) but item groups and item type, but Sales_amount must be based on items, not on item groups.

So I know that somehow I should use aggr function, but I don't understand where and how. Please, help me.

[#2]

Try like below with multi AGGR functions

IF(AGGR(Sum(Sales_Amount),item) < 500 , AGGR(Count(item),item_type))