Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I finally found the solution:
sum(if( aggr(sum(Qty),Group,Customer)>=Target,1,0))
Try:
Count(distinct aggr(if ( sum(Qty)>Target, Customer, Group),Customer))
Try this
Count(distinct aggr(if ( sum(Qty)>=Target, Customer, Group),Customer))
Regards
ABDALLA
I tried but I got the same result
Possibly QV is having trouble evaluating the Target in your function, but I'm not really sure - without a sample it's hard to tell or try different functions to see if any of them work.
I put a number instead of Target. But I got the same result. Any other Idea ?
I finally found the solution:
sum(if( aggr(sum(Qty),Group,Customer)>=Target,1,0))