Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try adjusting your expression with NoDistinct like this:
AGGR(NODISTINCT Sum(Qty)/2,Product)
Try adjusting your expression with NoDistinct like this:
AGGR(NODISTINCT Sum(Qty)/2,Product)
Thanks vegar
It's Working.
Is there any possible to hide Customer E Transaction in front-end??
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??
Anyone is this possible???