Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi m stuck off facing the problem but can't get success
please help me.
see the data of my table like this
MAT_CODE | MOV_TYPE | SALES |
A | 0 | 100 |
A | 1 | 200 |
A | 2 | 300 |
A | 5 | 400 |
B | 8 | 500 |
B | 9 | 600 |
C | 0 | 700 |
C | 5 | 800 |
C | 3 | 900 |
D | 7 | 1000 |
D | 10 | 1100 |
D | 2 | 1200 |
Now i want the output like this
MAT_CODE | SALES |
B | 1100 |
D | 3300 |
here i clarify to you that i want those MAT_COD that don't have MOV_TYPE equal to 0 and sum total of that SALES with MAT_COD
any help will be appreciated
hiii sir, flipside
you are right regarding to selection in list box the data comes all rather than to show selected value for resolving this problem i have done in calculated dimension like this
aggr(only({<MAT_CODE -=p({<MOV_TYPE={0}>})>}MAT_CODE),MAT_CODE)
and same expression as told by sir Gysbert Wassenaar
Regards