Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
)
count(
if(
count(Distinct
if(aggr(sum(ProductQuantity),ProductBrand)>=sum(TargetForProduct), BrandProduct)
>=sum(TargetOfBrands),
ClientName)