6 Replies Latest reply: Jun 27, 2010 12:42 PM by dacquet RSS

    URGENT : Problem with dimension - Aggr

    dacquet

      I have a dimension Group (group of products) and I have a target on each group. Let's say for the group1 the target is 100.

      It means that customer should by 100 products of group1. I need to display the number of customers who reach this target

      I use a pivot table with the dimension Group and an expression:

      Count(distinct aggr(if ( sum(Qty)>Target, Customer),Customer))

      It give me result but below what I expect but if I select one of the group I get the correct result.

       

      Group1 4

      Group2 6

       

      if I select Group1

       

      Group1 36

       

      Do you know why I got a different result when I select one of the group ?

       

      Thanks