1 Reply Latest reply: Jul 5, 2013 5:41 AM by Vishwaranjan Kumar RSS

    Aggregation for clients count base of target

      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)







      )