Aggregation for clients count base of target

[#1]

I need a report for number of clients for sellers. I have field for target products, target brands and target clients. I need Sellers, regions, level of performance and actual performance as dimensions. If some of sallers reach exact level of performance for product and product brands, I have to increase number of clients in target group. I have field for this target in

TargetOfBrands

.

But I can't realize what aggregation I need in dimensions. I have values for products, but they aren't distributed for level of performance

if

(



if(

aggr(

sum(ProductQuantity)

,ProductBrand)

>=sum(TargetForProduct)

,count(Distinct BrandProduct))

>=sum(TargetOfBrands)

,





count( ClientName)







)

[#2]

count(

if(

count(Distinct

if(aggr(sum(ProductQuantity),ProductBrand)>=sum(TargetForProduct), BrandProduct)

>=sum(TargetOfBrands),
ClientName)