Aggr using 2 dimension

[marishnagendran]

Dear All,

Product	Customer	Qty	AGGR(Sum(Qty)/2,Product)
Product A	Customer A	10	35
	Customer B	20
	Customer C	30
	Customer D	10
Product B	Customer A	20	50
	Customer E	50
	Customer F	30

Last AGGR function is used for sum of Quantity for each product and divide by 2 is my bench march for that product. i want to compare value for each customer

For Example

Product A Bench mark sales is 35

All customer bought the qty below 35 so i want color it(Customer A,B,C,D)

Product B Bench mark sales is 50. 

Customer A and Customer F I want to color it

[Vegar · Accepted solution]

Try adjusting your expression with NoDistinct like this:

AGGR(NODISTINCT Sum(Qty)/2,Product)

[marishnagendran]

Thanks vegar

It's Working.

Is there any possible to hide Customer E Transaction in front-end??

[Vegar]

You can't exclude them from the application, but you can exclude them from
you expressions by using SET analysis.

Example:
=SUM({< Customer -={'Customer E'} >}Qty)

[marishnagendran]

No I'm not asking like that

Product	Customer	Qty	AGGR(NoDistinct Sum(Qty)/2,Product)
Product A	Customer A	10	35
	Customer B	20	35
	Customer C	30	35
	Customer D	10	35
Product B	Customer A	20	50
	Customer E	50	50
	Customer F	30	50

Now the transaction table comes like this.

If Qty and AGGR(Nodistinct Sum(Qty)/2,Product) column is equal or above the value that transaction i want to remove in my front end it is possible??

[marishnagendran]

Anyone is this possible???

[Vegar]

What if you f do like this
Change the expression to something like the following?

If(Qty < AGGR(Nodistinct Sum(Qty)/2,Product),
AGGR(Nodistinct Sum(Qty)/2,Product),
Null())